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=985 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=985SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=677SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=985 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catoblepia' AND (junior_species='amphirhoe' OR junior_species='amphirhoe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catoblepia' AND (species='amphirhoe' OR species='amphirhoe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catoblepia' AND (species='amphirhoe' OR species='amphirhoe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catoblepia' AND (junior_species='amphirhoe' OR junior_species='amphirhoe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catoblepia' AND (species='amphirhoe' OR species='amphirhoe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynastor' AND (junior_species='darius' OR junior_species='darius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dynastor' AND (species='darius' OR species='darius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dynastor' AND (species='darius' OR species='darius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynastor' AND (junior_species='darius' OR junior_species='darius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dynastor' AND (species='darius' OR species='darius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eryphanis' AND (junior_species='reevesii' OR junior_species='reevesi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eryphanis' AND (species='reevesii' OR species='reevesi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eryphanis' AND (species='reevesii' OR species='reevesi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eryphanis' AND (junior_species='reevesii' OR junior_species='reevesi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eryphanis' AND (species='reevesii' OR species='reevesi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='aega' OR junior_species='aega')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Morpho' AND (species='aega' OR species='aega') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Morpho' AND (species='aega' OR species='aega')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='aega' OR junior_species='aega')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Morpho' AND (species='aega' OR species='aega') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='helenor' OR junior_species='helenor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Morpho' AND (species='helenor' OR species='helenor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Morpho' AND (species='helenor' OR species='helenor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='helenor' OR junior_species='helenor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Morpho' AND (species='helenor' OR species='helenor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dircenna' AND (junior_species='dero' OR junior_species='dero')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dircenna' AND (species='dero' OR species='dero') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dircenna' AND (species='dero' OR species='dero')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dircenna' AND (junior_species='dero' OR junior_species='dero')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dircenna' AND (species='dero' OR species='dero') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Episcada' AND (junior_species='hymenaea' OR junior_species='hymenaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Episcada' AND (species='hymenaea' OR species='hymenaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Episcada' AND (species='hymenaea' OR species='hymenaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Episcada' AND (junior_species='hymenaea' OR junior_species='hymenaea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Episcada' AND (species='hymenaea' OR species='hymenaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epityches' AND (junior_species='eupompe' OR junior_species='eupompe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epityches' AND (species='eupompe' OR species='eupompe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epityches' AND (species='eupompe' OR species='eupompe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epityches' AND (junior_species='eupompe' OR junior_species='eupompe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Epityches' AND (species='eupompe' OR species='eupompe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mcclungia' AND (junior_species='cymo' OR junior_species='cymo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mcclungia' AND (species='cymo' OR species='cymo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mcclungia' AND (species='cymo' OR species='cymo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mcclungia' AND (junior_species='cymo' OR junior_species='cymo')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mcclungia' AND (species='cymo' OR species='cymo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mechanitis' AND (junior_species='lysimnia' OR junior_species='lysimnia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mechanitis' AND (species='lysimnia' OR species='lysimnia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mechanitis' AND (species='lysimnia' OR species='lysimnia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mechanitis' AND (junior_species='lysimnia' OR junior_species='lysimnia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mechanitis' AND (species='lysimnia' OR species='lysimnia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Methona' AND (junior_species='themisto' OR junior_species='themisto')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Methona' AND (species='themisto' OR species='themisto') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Methona' AND (species='themisto' OR species='themisto')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Methona' AND (junior_species='themisto' OR junior_species='themisto')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Methona' AND (species='themisto' OR species='themisto') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Placidina' AND (junior_species='euryanassa' OR junior_species='euryanassa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Placidina' AND (species='euryanassa' OR species='euryanassa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Placidina' AND (species='euryanassa' OR species='euryanassa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Placidina' AND (junior_species='euryanassa' OR junior_species='euryanassa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Placidina' AND (species='euryanassa' OR species='euryanassa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoscada' AND (junior_species='erruca' OR junior_species='erruca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoscada' AND (species='erruca' OR species='erruca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoscada' AND (species='erruca' OR species='erruca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoscada' AND (junior_species='erruca' OR junior_species='erruca')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudoscada' AND (species='erruca' OR species='erruca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pteronymia' AND (junior_species='sylvo' OR junior_species='sylvo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pteronymia' AND (species='sylvo' OR species='sylvo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pteronymia' AND (species='sylvo' OR species='sylvo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pteronymia' AND (junior_species='sylvo' OR junior_species='sylvo')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pteronymia' AND (species='sylvo' OR species='sylvo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinote' AND (junior_species='discrepans' OR junior_species='discrepans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Actinote' AND (species='discrepans' OR species='discrepans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Actinote' AND (species='discrepans' OR species='discrepans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinote' AND (junior_species='discrepans' OR junior_species='discrepans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Actinote' AND (species='discrepans' OR species='discrepans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinote' AND (junior_species='melanisans' OR junior_species='melanisans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Actinote' AND (species='melanisans' OR species='melanisans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Actinote' AND (species='melanisans' OR species='melanisans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinote' AND (junior_species='melanisans' OR junior_species='melanisans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Actinote' AND (species='melanisans' OR species='melanisans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinote' AND (junior_species='pellenea' OR junior_species='pellenea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Actinote' AND (species='pellenea' OR species='pellenea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Actinote' AND (species='pellenea' OR species='pellenea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinote' AND (junior_species='pellenea' OR junior_species='pellenea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Actinote' AND (species='pellenea' OR species='pellenea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agraulis' AND (junior_species='vanillae' OR junior_species='vanillae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agraulis' AND (species='vanillae' OR species='vanillae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agraulis' AND (species='vanillae' OR species='vanillae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agraulis' AND (junior_species='vanillae' OR junior_species='vanillae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agraulis' AND (species='vanillae' OR species='vanillae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dione' AND (junior_species='juno' OR junior_species='juno')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dione' AND (species='juno' OR species='juno') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dione' AND (species='juno' OR species='juno')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dione' AND (junior_species='juno' OR junior_species='juno')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dione' AND (species='juno' OR species='juno') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dione' AND (junior_species='moneta' OR junior_species='moneta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dione' AND (species='moneta' OR species='moneta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dione' AND (species='moneta' OR species='moneta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dione' AND (junior_species='moneta' OR junior_species='moneta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dione' AND (species='moneta' OR species='moneta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dryas' AND (junior_species='iulia' OR junior_species='iulia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dryas' AND (species='iulia' OR species='iulia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dryas' AND (species='iulia' OR species='iulia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dryas' AND (junior_species='iulia' OR junior_species='iulia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dryas' AND (species='iulia' OR species='iulia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euides' AND (junior_species='aliphera' OR junior_species='aliphera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euides' AND (species='aliphera' OR species='aliphera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euides' AND (species='aliphera' OR species='aliphera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euides' AND (junior_species='aliphera' OR junior_species='aliphera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euides' AND (species='aliphera' OR species='aliphera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='erato' OR junior_species='erato')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='erato' OR species='erato') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='erato' OR species='erato')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='erato' OR junior_species='erato')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliconius' AND (species='erato' OR species='erato') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='ethilla' OR junior_species='ethilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='ethilla' OR species='ethilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='ethilla' OR species='ethilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='ethilla' OR junior_species='ethilla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliconius' AND (species='ethilla' OR species='ethilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anartia' AND (junior_species='amathea' OR junior_species='amathea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anartia' AND (species='amathea' OR species='amathea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anartia' AND (species='amathea' OR species='amathea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anartia' AND (junior_species='amathea' OR junior_species='amathea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anartia' AND (species='amathea' OR species='amathea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlosyne' AND (junior_species='lacinia' OR junior_species='lacinia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlosyne' AND (species='lacinia' OR species='lacinia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlosyne' AND (species='lacinia' OR species='lacinia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlosyne' AND (junior_species='lacinia' OR junior_species='lacinia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chlosyne' AND (species='lacinia' OR species='lacinia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eresia' AND (junior_species='lansdorfi' OR junior_species='lansdorfii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eresia' AND (species='lansdorfi' OR species='lansdorfii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eresia' AND (species='lansdorfi' OR species='lansdorfii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eresia' AND (junior_species='lansdorfi' OR junior_species='lansdorfii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eresia' AND (species='lansdorfi' OR species='lansdorfii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypanartia' AND (junior_species='bella' OR junior_species='bella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypanartia' AND (species='bella' OR species='bella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypanartia' AND (species='bella' OR species='bella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypanartia' AND (junior_species='bella' OR junior_species='bella')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypanartia' AND (species='bella' OR species='bella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypanartia' AND (junior_species='lethe' OR junior_species='lethe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypanartia' AND (species='lethe' OR species='lethe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypanartia' AND (species='lethe' OR species='lethe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypanartia' AND (junior_species='lethe' OR junior_species='lethe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypanartia' AND (species='lethe' OR species='lethe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='evarete' OR junior_species='evarete')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='evarete' OR species='evarete') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='evarete' OR species='evarete')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='evarete' OR junior_species='evarete')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Junonia' AND (species='evarete' OR species='evarete') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ortilia' AND (junior_species='ithra' OR junior_species='ithra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ortilia' AND (species='ithra' OR species='ithra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ortilia' AND (species='ithra' OR species='ithra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ortilia' AND (junior_species='ithra' OR junior_species='ithra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ortilia' AND (species='ithra' OR species='ithra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ortilia' AND (junior_species='orthia' OR junior_species='orthia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ortilia' AND (species='orthia' OR species='orthia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ortilia' AND (species='orthia' OR species='orthia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ortilia' AND (junior_species='orthia' OR junior_species='orthia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ortilia' AND (species='orthia' OR species='orthia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siproeta' AND (junior_species='epaphus' OR junior_species='epaphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Siproeta' AND (species='epaphus' OR species='epaphus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Siproeta' AND (species='epaphus' OR species='epaphus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siproeta' AND (junior_species='epaphus' OR junior_species='epaphus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Siproeta' AND (species='epaphus' OR species='epaphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tegosa' AND (junior_species='claudina' OR junior_species='claudina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tegosa' AND (species='claudina' OR species='claudina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tegosa' AND (species='claudina' OR species='claudina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tegosa' AND (junior_species='claudina' OR junior_species='claudina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tegosa' AND (species='claudina' OR species='claudina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='braziliensis' OR junior_species='braziliensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanessa' AND (species='braziliensis' OR species='braziliensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanessa' AND (species='braziliensis' OR species='braziliensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='braziliensis' OR junior_species='braziliensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vanessa' AND (species='braziliensis' OR species='braziliensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Biblis' AND (junior_species='hyperia' OR junior_species='hyperia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Biblis' AND (species='hyperia' OR species='hyperia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Biblis' AND (species='hyperia' OR species='hyperia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Biblis' AND (junior_species='hyperia' OR junior_species='hyperia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Biblis' AND (species='hyperia' OR species='hyperia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicore' AND (junior_species='hydaspes' OR junior_species='hydaspes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callicore' AND (species='hydaspes' OR species='hydaspes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callicore' AND (species='hydaspes' OR species='hydaspes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicore' AND (junior_species='hydaspes' OR junior_species='hydaspes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Callicore' AND (species='hydaspes' OR species='hydaspes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicore' AND (junior_species='pygas' OR junior_species='pygas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callicore' AND (species='pygas' OR species='pygas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callicore' AND (species='pygas' OR species='pygas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicore' AND (junior_species='pygas' OR junior_species='pygas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Callicore' AND (species='pygas' OR species='pygas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catonephele' AND (junior_species='numilia' OR junior_species='numilia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catonephele' AND (species='numilia' OR species='numilia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catonephele' AND (species='numilia' OR species='numilia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catonephele' AND (junior_species='numilia' OR junior_species='numilia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catonephele' AND (species='numilia' OR species='numilia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaethria' AND (junior_species='candrena' OR junior_species='candrena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diaethria' AND (species='candrena' OR species='candrena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diaethria' AND (species='candrena' OR species='candrena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaethria' AND (junior_species='candrena' OR junior_species='candrena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diaethria' AND (species='candrena' OR species='candrena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaethria' AND (junior_species='meridionalis' OR junior_species='meridionalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diaethria' AND (species='meridionalis' OR species='meridionalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diaethria' AND (species='meridionalis' OR species='meridionalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaethria' AND (junior_species='meridionalis' OR junior_species='meridionalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diaethria' AND (species='meridionalis' OR species='meridionalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='athemon' OR junior_species='athemon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dynamine' AND (species='athemon' OR species='athemon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dynamine' AND (species='athemon' OR species='athemon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='athemon' OR junior_species='athemon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dynamine' AND (species='athemon' OR species='athemon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='coenus' OR junior_species='coenus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dynamine' AND (species='coenus' OR species='coenus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dynamine' AND (species='coenus' OR species='coenus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='coenus' OR junior_species='coenus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dynamine' AND (species='coenus' OR species='coenus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='myrrhina' OR junior_species='myrrhina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dynamine' AND (species='myrrhina' OR species='myrrhina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dynamine' AND (species='myrrhina' OR species='myrrhina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='myrrhina' OR junior_species='myrrhina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dynamine' AND (species='myrrhina' OR species='myrrhina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='tithia' OR junior_species='tithia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dynamine' AND (species='tithia' OR species='tithia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dynamine' AND (species='tithia' OR species='tithia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='tithia' OR junior_species='tithia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dynamine' AND (species='tithia' OR species='tithia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiphile' AND (junior_species='orea' OR junior_species='orea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epiphile' AND (species='orea' OR species='orea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epiphile' AND (species='orea' OR species='orea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiphile' AND (junior_species='orea' OR junior_species='orea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Epiphile' AND (species='orea' OR species='orea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunica' AND (junior_species='eburnea' OR junior_species='eburnea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eunica' AND (species='eburnea' OR species='eburnea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eunica' AND (species='eburnea' OR species='eburnea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunica' AND (junior_species='eburnea' OR junior_species='eburnea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eunica' AND (species='eburnea' OR species='eburnea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='amphinome' OR junior_species='amphinome')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='amphinome' OR species='amphinome') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='amphinome' OR species='amphinome')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='amphinome' OR junior_species='amphinome')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hamadryas' AND (species='amphinome' OR species='amphinome') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='epinome' OR junior_species='epinome')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='epinome' OR species='epinome') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='epinome' OR species='epinome')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='epinome' OR junior_species='epinome')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hamadryas' AND (species='epinome' OR species='epinome') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='fornax' OR junior_species='fornax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='fornax' OR species='fornax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='fornax' OR species='fornax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='fornax' OR junior_species='fornax')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hamadryas' AND (species='fornax' OR species='fornax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myscelia' AND (junior_species='orsis' OR junior_species='orsis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myscelia' AND (species='orsis' OR species='orsis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myscelia' AND (species='orsis' OR species='orsis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myscelia' AND (junior_species='orsis' OR junior_species='orsis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myscelia' AND (species='orsis' OR species='orsis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paulogramma' AND (junior_species='pyracmon' OR junior_species='pyracmon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paulogramma' AND (species='pyracmon' OR species='pyracmon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paulogramma' AND (species='pyracmon' OR species='pyracmon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paulogramma' AND (junior_species='pyracmon' OR junior_species='pyracmon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paulogramma' AND (species='pyracmon' OR species='pyracmon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eteona' AND (junior_species='tisiphone' OR junior_species='tisiphone')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eteona' AND (species='tisiphone' OR species='tisiphone') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eteona' AND (species='tisiphone' OR species='tisiphone')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eteona' AND (junior_species='tisiphone' OR junior_species='tisiphone')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eteona' AND (species='tisiphone' OR species='tisiphone') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsterinaria' AND (junior_species='necys' OR junior_species='necys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Forsterinaria' AND (species='necys' OR species='necys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Forsterinaria' AND (species='necys' OR species='necys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsterinaria' AND (junior_species='necys' OR junior_species='necys')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Forsterinaria' AND (species='necys' OR species='necys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsterinaria' AND (junior_species='quantius' OR junior_species='quantius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Forsterinaria' AND (species='quantius' OR species='quantius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Forsterinaria' AND (species='quantius' OR species='quantius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsterinaria' AND (junior_species='quantius' OR junior_species='quantius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Forsterinaria' AND (species='quantius' OR species='quantius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Godartiana' AND (junior_species='muscosa' OR junior_species='muscosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Godartiana' AND (species='muscosa' OR species='muscosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Godartiana' AND (species='muscosa' OR species='muscosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Godartiana' AND (junior_species='muscosa' OR junior_species='muscosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Godartiana' AND (species='muscosa' OR species='muscosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moneuptychia' AND (junior_species='paeon' OR junior_species='paeon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Moneuptychia' AND (species='paeon' OR species='paeon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moneuptychia' AND (species='paeon' OR species='paeon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moneuptychia' AND (junior_species='paeon' OR junior_species='paeon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Moneuptychia' AND (species='paeon' OR species='paeon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareuptychia' AND (junior_species='summandosa' OR junior_species='summandosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pareuptychia' AND (species='summandosa' OR species='summandosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pareuptychia' AND (species='summandosa' OR species='summandosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareuptychia' AND (junior_species='summandosa' OR junior_species='summandosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pareuptychia' AND (species='summandosa' OR species='summandosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='poltys' OR junior_species='poltys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paryphthimoides' AND (species='poltys' OR species='poltys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paryphthimoides' AND (species='poltys' OR species='poltys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='poltys' OR junior_species='poltys')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paryphthimoides' AND (species='poltys' OR species='poltys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Praepedaliodes' AND (junior_species='phanias' OR junior_species='phanias')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Praepedaliodes' AND (species='phanias' OR species='phanias') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Praepedaliodes' AND (species='phanias' OR species='phanias')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Praepedaliodes' AND (junior_species='phanias' OR junior_species='phanias')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Praepedaliodes' AND (species='phanias' OR species='phanias') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudodebis' AND (junior_species='euptychidia' OR junior_species='euptychidia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudodebis' AND (species='euptychidia' OR species='euptychidia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudodebis' AND (species='euptychidia' OR species='euptychidia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudodebis' AND (junior_species='euptychidia' OR junior_species='euptychidia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudodebis' AND (species='euptychidia' OR species='euptychidia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Splendeuptychia' AND (junior_species='libitina' OR junior_species='libitina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Splendeuptychia' AND (species='libitina' OR species='libitina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Splendeuptychia' AND (species='libitina' OR species='libitina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Splendeuptychia' AND (junior_species='libitina' OR junior_species='libitina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Splendeuptychia' AND (species='libitina' OR species='libitina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='tripunctata' OR junior_species='tripunctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taygetis' AND (species='tripunctata' OR species='tripunctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taygetis' AND (species='tripunctata' OR species='tripunctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='tripunctata' OR junior_species='tripunctata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Taygetis' AND (species='tripunctata' OR species='tripunctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='ypthima' OR junior_species='ypthima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taygetis' AND (species='ypthima' OR species='ypthima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taygetis' AND (species='ypthima' OR species='ypthima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='ypthima' OR junior_species='ypthima')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Taygetis' AND (species='ypthima' OR species='ypthima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='celmis' OR junior_species='celmis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Yphthimoides' AND (species='celmis' OR species='celmis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Yphthimoides' AND (species='celmis' OR species='celmis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='celmis' OR junior_species='celmis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Yphthimoides' AND (species='celmis' OR species='celmis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='straminae' OR junior_species='straminae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Yphthimoides' AND (species='straminae' OR species='straminae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Yphthimoides' AND (species='straminae' OR species='straminae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='straminae' OR junior_species='straminae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Yphthimoides' AND (species='straminae' OR species='straminae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doxocopa' AND (junior_species='kallina' OR junior_species='kallina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Doxocopa' AND (species='kallina' OR species='kallina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Doxocopa' AND (species='kallina' OR species='kallina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doxocopa' AND (junior_species='kallina' OR junior_species='kallina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Doxocopa' AND (species='kallina' OR species='kallina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doxocopa' AND (junior_species='laurentia' OR junior_species='laurentia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Doxocopa' AND (species='laurentia' OR species='laurentia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Doxocopa' AND (species='laurentia' OR species='laurentia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doxocopa' AND (junior_species='laurentia' OR junior_species='laurentia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Doxocopa' AND (species='laurentia' OR species='laurentia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypna' AND (junior_species='clytemnestra' OR junior_species='clytemnestra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypna' AND (species='clytemnestra' OR species='clytemnestra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypna' AND (species='clytemnestra' OR species='clytemnestra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypna' AND (junior_species='clytemnestra' OR junior_species='clytemnestra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypna' AND (species='clytemnestra' OR species='clytemnestra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='moruus' OR junior_species='moruus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Memphis' AND (species='moruus' OR species='moruus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memphis' AND (species='moruus' OR species='moruus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='moruus' OR junior_species='moruus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Memphis' AND (species='moruus' OR species='moruus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='falcipennis' OR junior_species='falcipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='falcipennis' OR species='falcipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='falcipennis' OR species='falcipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='falcipennis' OR junior_species='falcipennis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Adelpha' AND (species='falcipennis' OR species='falcipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='malea' OR junior_species='malea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='malea' OR species='malea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='malea' OR species='malea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='malea' OR junior_species='malea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Adelpha' AND (species='malea' OR species='malea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='syma' OR junior_species='syma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='syma' OR species='syma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='syma' OR species='syma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='syma' OR junior_species='syma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Adelpha' AND (species='syma' OR species='syma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='thessalia' OR junior_species='thessalia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='thessalia' OR species='thessalia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='thessalia' OR species='thessalia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='thessalia' OR junior_species='thessalia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Adelpha' AND (species='thessalia' OR species='thessalia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='zea' OR junior_species='zea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='zea' OR species='zea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='zea' OR species='zea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='zea' OR junior_species='zea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Adelpha' AND (species='zea' OR species='zea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libytheana' AND (junior_species='carinenta' OR junior_species='carinenta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Libytheana' AND (species='carinenta' OR species='carinenta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Libytheana' AND (species='carinenta' OR species='carinenta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libytheana' AND (junior_species='carinenta' OR junior_species='carinenta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Libytheana' AND (species='carinenta' OR species='carinenta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='erippus' OR junior_species='erippus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Danaus' AND (species='erippus' OR species='erippus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Danaus' AND (species='erippus' OR species='erippus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='erippus' OR junior_species='erippus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Danaus' AND (species='erippus' OR species='erippus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Battus' AND (junior_species='polydamas' OR junior_species='polydamas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Battus' AND (species='polydamas' OR species='polydamas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Battus' AND (species='polydamas' OR species='polydamas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Battus' AND (junior_species='polydamas' OR junior_species='polydamas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Battus' AND (species='polydamas' OR species='polydamas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Battus' AND (junior_species='polystictus' OR junior_species='polystictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Battus' AND (species='polystictus' OR species='polystictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Battus' AND (species='polystictus' OR species='polystictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Battus' AND (junior_species='polystictus' OR junior_species='polystictus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Battus' AND (species='polystictus' OR species='polystictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heraclides' AND (junior_species='anchisiades' OR junior_species='anchisiades')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heraclides' AND (species='anchisiades' OR species='anchisiades') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heraclides' AND (species='anchisiades' OR species='anchisiades')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heraclides' AND (junior_species='anchisiades' OR junior_species='anchisiades')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heraclides' AND (species='anchisiades' OR species='anchisiades') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heraclides' AND (junior_species='astyalus' OR junior_species='astyalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heraclides' AND (species='astyalus' OR species='astyalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heraclides' AND (species='astyalus' OR species='astyalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heraclides' AND (junior_species='astyalus' OR junior_species='astyalus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heraclides' AND (species='astyalus' OR species='astyalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heraclides' AND (junior_species='hectorides' OR junior_species='hectorides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heraclides' AND (species='hectorides' OR species='hectorides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heraclides' AND (species='hectorides' OR species='hectorides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heraclides' AND (junior_species='hectorides' OR junior_species='hectorides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heraclides' AND (species='hectorides' OR species='hectorides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimoides' AND (junior_species='lysithous' OR junior_species='lysithous')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mimoides' AND (species='lysithous' OR species='lysithous') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mimoides' AND (species='lysithous' OR species='lysithous')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimoides' AND (junior_species='lysithous' OR junior_species='lysithous')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mimoides' AND (species='lysithous' OR species='lysithous') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parides' AND (junior_species='agavus' OR junior_species='agavus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parides' AND (species='agavus' OR species='agavus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parides' AND (species='agavus' OR species='agavus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parides' AND (junior_species='agavus' OR junior_species='agavus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parides' AND (species='agavus' OR species='agavus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parides' AND (junior_species='anchises' OR junior_species='anchises')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parides' AND (species='anchises' OR species='anchises') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parides' AND (species='anchises' OR species='anchises')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parides' AND (junior_species='anchises' OR junior_species='anchises')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parides' AND (species='anchises' OR species='anchises') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protesilaus' AND (junior_species='stenodesmus' OR junior_species='stenodesmus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protesilaus' AND (species='stenodesmus' OR species='stenodesmus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protesilaus' AND (species='stenodesmus' OR species='stenodesmus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protesilaus' AND (junior_species='stenodesmus' OR junior_species='stenodesmus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protesilaus' AND (species='stenodesmus' OR species='stenodesmus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphrissa' AND (junior_species='statira' OR junior_species='statira')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphrissa' AND (species='statira' OR species='statira') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphrissa' AND (species='statira' OR species='statira')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphrissa' AND (junior_species='statira' OR junior_species='statira')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aphrissa' AND (species='statira' OR species='statira') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='deva' OR junior_species='deva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='deva' OR species='deva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='deva' OR species='deva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='deva' OR junior_species='deva')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eurema' AND (species='deva' OR species='deva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='argante' OR junior_species='argante')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoebis' AND (species='argante' OR species='argante') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoebis' AND (species='argante' OR species='argante')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='argante' OR junior_species='argante')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phoebis' AND (species='argante' OR species='argante') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='neocypris' OR junior_species='neocypris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoebis' AND (species='neocypris' OR species='neocypris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoebis' AND (species='neocypris' OR species='neocypris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='neocypris' OR junior_species='neocypris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phoebis' AND (species='neocypris' OR species='neocypris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='philea' OR junior_species='philea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoebis' AND (species='philea' OR species='philea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoebis' AND (species='philea' OR species='philea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='philea' OR junior_species='philea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phoebis' AND (species='philea' OR species='philea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='sennae' OR junior_species='sennae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoebis' AND (species='sennae' OR species='sennae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoebis' AND (species='sennae' OR species='sennae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='sennae' OR junior_species='sennae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phoebis' AND (species='sennae' OR species='sennae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhabdodryas' AND (junior_species='trite' OR junior_species='trite')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhabdodryas' AND (species='trite' OR species='trite') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhabdodryas' AND (species='trite' OR species='trite')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhabdodryas' AND (junior_species='trite' OR junior_species='trite')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhabdodryas' AND (species='trite' OR species='trite') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dismorphia' AND (junior_species='astyocha' OR junior_species='astyocha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dismorphia' AND (species='astyocha' OR species='astyocha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dismorphia' AND (species='astyocha' OR species='astyocha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dismorphia' AND (junior_species='astyocha' OR junior_species='astyocha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dismorphia' AND (species='astyocha' OR species='astyocha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudopieris' AND (junior_species='nehemia' OR junior_species='nehemia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudopieris' AND (species='nehemia' OR species='nehemia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudopieris' AND (species='nehemia' OR species='nehemia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudopieris' AND (junior_species='nehemia' OR junior_species='nehemia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudopieris' AND (species='nehemia' OR species='nehemia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ascia' AND (junior_species='monuste' OR junior_species='monuste')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ascia' AND (species='monuste' OR species='monuste') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ascia' AND (species='monuste' OR species='monuste')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ascia' AND (junior_species='monuste' OR junior_species='monuste')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ascia' AND (species='monuste' OR species='monuste') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tatochila' AND (junior_species='autodice' OR junior_species='autodice')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tatochila' AND (species='autodice' OR species='autodice') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tatochila' AND (species='autodice' OR species='autodice')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tatochila' AND (junior_species='autodice' OR junior_species='autodice')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tatochila' AND (species='autodice' OR species='autodice') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Barbicornis' AND (junior_species='basilis' OR junior_species='basilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Barbicornis' AND (species='basilis' OR species='basilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Barbicornis' AND (species='basilis' OR species='basilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Barbicornis' AND (junior_species='basilis' OR junior_species='basilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Barbicornis' AND (species='basilis' OR species='basilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emesis' AND (junior_species='diogenia' OR junior_species='diogenia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emesis' AND (species='diogenia' OR species='diogenia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emesis' AND (species='diogenia' OR species='diogenia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emesis' AND (junior_species='diogenia' OR junior_species='diogenia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Emesis' AND (species='diogenia' OR species='diogenia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emesis' AND (junior_species='russula' OR junior_species='russula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emesis' AND (species='russula' OR species='russula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emesis' AND (species='russula' OR species='russula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emesis' AND (junior_species='russula' OR junior_species='russula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Emesis' AND (species='russula' OR species='russula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euselasia' AND (junior_species='hygenius' OR junior_species='hygenius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euselasia' AND (species='hygenius' OR species='hygenius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euselasia' AND (species='hygenius' OR species='hygenius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euselasia' AND (junior_species='hygenius' OR junior_species='hygenius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euselasia' AND (species='hygenius' OR species='hygenius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arawacus' AND (junior_species='meliboeus' OR junior_species='meliboeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arawacus' AND (species='meliboeus' OR species='meliboeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arawacus' AND (species='meliboeus' OR species='meliboeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arawacus' AND (junior_species='meliboeus' OR junior_species='meliboeus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arawacus' AND (species='meliboeus' OR species='meliboeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arawacus' AND (junior_species='separata' OR junior_species='separata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arawacus' AND (species='separata' OR species='separata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arawacus' AND (species='separata' OR species='separata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arawacus' AND (junior_species='separata' OR junior_species='separata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arawacus' AND (species='separata' OR species='separata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calycopis' AND (junior_species='caulonia' OR junior_species='caulonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calycopis' AND (species='caulonia' OR species='caulonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calycopis' AND (species='caulonia' OR species='caulonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calycopis' AND (junior_species='caulonia' OR junior_species='caulonia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Calycopis' AND (species='caulonia' OR species='caulonia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudolycaena' AND (junior_species='marsyas' OR junior_species='marsyas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudolycaena' AND (species='marsyas' OR species='marsyas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudolycaena' AND (species='marsyas' OR species='marsyas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudolycaena' AND (junior_species='marsyas' OR junior_species='marsyas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudolycaena' AND (species='marsyas' OR species='marsyas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='eurytulus' OR junior_species='eurytulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strymon' AND (species='eurytulus' OR species='eurytulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strymon' AND (species='eurytulus' OR species='eurytulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='eurytulus' OR junior_species='eurytulus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strymon' AND (species='eurytulus' OR species='eurytulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Achlyodes' AND (junior_species='busirus' OR junior_species='busirus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Achlyodes' AND (species='busirus' OR species='busirus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Achlyodes' AND (species='busirus' OR species='busirus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Achlyodes' AND (junior_species='busirus' OR junior_species='busirus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Achlyodes' AND (species='busirus' OR species='busirus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Achlyodes' AND (junior_species='mithridates' OR junior_species='mithridates')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Achlyodes' AND (species='mithridates' OR species='mithridates') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Achlyodes' AND (species='mithridates' OR species='mithridates')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Achlyodes' AND (junior_species='mithridates' OR junior_species='mithridates')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Achlyodes' AND (species='mithridates' OR species='mithridates') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astraptes' AND (junior_species='anaphus' OR junior_species='anaphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Astraptes' AND (species='anaphus' OR species='anaphus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Astraptes' AND (species='anaphus' OR species='anaphus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astraptes' AND (junior_species='anaphus' OR junior_species='anaphus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Astraptes' AND (species='anaphus' OR species='anaphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astraptes' AND (junior_species='fulgerator' OR junior_species='fulgerator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Astraptes' AND (species='fulgerator' OR species='fulgerator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Astraptes' AND (species='fulgerator' OR species='fulgerator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astraptes' AND (junior_species='fulgerator' OR junior_species='fulgerator')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Astraptes' AND (species='fulgerator' OR species='fulgerator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Codatractus' AND (junior_species='aminias' OR junior_species='aminias')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Codatractus' AND (species='aminias' OR species='aminias') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Codatractus' AND (species='aminias' OR species='aminias')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Codatractus' AND (junior_species='aminias' OR junior_species='aminias')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Codatractus' AND (species='aminias' OR species='aminias') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliopetes' AND (junior_species='alana' OR junior_species='alana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliopetes' AND (species='alana' OR species='alana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliopetes' AND (species='alana' OR species='alana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliopetes' AND (junior_species='alana' OR junior_species='alana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliopetes' AND (species='alana' OR species='alana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliopetes' AND (junior_species='arsalte' OR junior_species='arsalte')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliopetes' AND (species='arsalte' OR species='arsalte') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliopetes' AND (species='arsalte' OR species='arsalte')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliopetes' AND (junior_species='arsalte' OR junior_species='arsalte')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliopetes' AND (species='arsalte' OR species='arsalte') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliopetes' AND (junior_species='omrina' OR junior_species='omrina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliopetes' AND (species='omrina' OR species='omrina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliopetes' AND (species='omrina' OR species='omrina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliopetes' AND (junior_species='omrina' OR junior_species='omrina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliopetes' AND (species='omrina' OR species='omrina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pellicia' AND (junior_species='vecina' OR junior_species='vecina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pellicia' AND (species='vecina' OR species='vecina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pellicia' AND (species='vecina' OR species='vecina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pellicia' AND (junior_species='vecina' OR junior_species='vecina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pellicia' AND (species='vecina' OR species='vecina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonus' AND (junior_species='leo' OR junior_species='leo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polygonus' AND (species='leo' OR species='leo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polygonus' AND (species='leo' OR species='leo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonus' AND (junior_species='leo' OR junior_species='leo')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polygonus' AND (species='leo' OR species='leo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgus' AND (junior_species='orcus' OR junior_species='orcus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrgus' AND (species='orcus' OR species='orcus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrgus' AND (species='orcus' OR species='orcus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgus' AND (junior_species='orcus' OR junior_species='orcus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyrgus' AND (species='orcus' OR species='orcus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='doryssus' OR junior_species='doryssus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urbanus' AND (species='doryssus' OR species='doryssus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urbanus' AND (species='doryssus' OR species='doryssus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='doryssus' OR junior_species='doryssus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Urbanus' AND (species='doryssus' OR species='doryssus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='proteus' OR junior_species='proteus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urbanus' AND (species='proteus' OR species='proteus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urbanus' AND (species='proteus' OR species='proteus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='proteus' OR junior_species='proteus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Urbanus' AND (species='proteus' OR species='proteus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='simplicius' OR junior_species='simplicius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urbanus' AND (species='simplicius' OR species='simplicius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urbanus' AND (species='simplicius' OR species='simplicius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='simplicius' OR junior_species='simplicius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Urbanus' AND (species='simplicius' OR species='simplicius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='teleus' OR junior_species='teleus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urbanus' AND (species='teleus' OR species='teleus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urbanus' AND (species='teleus' OR species='teleus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='teleus' OR junior_species='teleus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Urbanus' AND (species='teleus' OR species='teleus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenophanes' AND (junior_species='tryxus' OR junior_species='tryxus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xenophanes' AND (species='tryxus' OR species='tryxus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xenophanes' AND (species='tryxus' OR species='tryxus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenophanes' AND (junior_species='tryxus' OR junior_species='tryxus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xenophanes' AND (species='tryxus' OR species='tryxus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zera' AND (junior_species='hyacinthinus' OR junior_species='hyacinthinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zera' AND (species='hyacinthinus' OR species='hyacinthinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zera' AND (species='hyacinthinus' OR species='hyacinthinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zera' AND (junior_species='hyacinthinus' OR junior_species='hyacinthinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zera' AND (species='hyacinthinus' OR species='hyacinthinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthoptus' AND (junior_species='epictetus' OR junior_species='epictetus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthoptus' AND (species='epictetus' OR species='epictetus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthoptus' AND (species='epictetus' OR species='epictetus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthoptus' AND (junior_species='epictetus' OR junior_species='epictetus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anthoptus' AND (species='epictetus' OR species='epictetus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylephila' AND (junior_species='phyleus' OR junior_species='phyleus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylephila' AND (species='phyleus' OR species='phyleus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylephila' AND (species='phyleus' OR species='phyleus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylephila' AND (junior_species='phyleus' OR junior_species='phyleus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hylephila' AND (species='phyleus' OR species='phyleus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Niconiades' AND (junior_species='merenda' OR junior_species='merenda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Niconiades' AND (species='merenda' OR species='merenda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Niconiades' AND (species='merenda' OR species='merenda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Niconiades' AND (junior_species='merenda' OR junior_species='merenda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Niconiades' AND (species='merenda' OR species='merenda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mysoria' AND (junior_species='barcastus' OR junior_species='barcastus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mysoria' AND (species='barcastus' OR species='barcastus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mysoria' AND (species='barcastus' OR species='barcastus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mysoria' AND (junior_species='barcastus' OR junior_species='barcastus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mysoria' AND (species='barcastus' OR species='barcastus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=985
The Ecological Register: Regional Integrated University of High Uruguay and Missions
Regional Integrated University of High Uruguay and Missions
Basic information
Sample name: Regional Integrated University of High Uruguay and Missions
Reference:D. Bonfantti, R. A. Di Mare, and R. Giovenardi. 2009. Butterflies (Lepidoptera: Papilionoidea and Hesperioidea) from two forest fragments. Check List5(4):819-829 [ER 677]
Habitat comments: 47 ha forest fragment
"subtropical humid (Cfa), with rainfall well distributed throughout the year"; the region was once "Atlantic Forest, sensu lato, classified as deciduous seasonal forest"
MAP said to be 1800 to 2100 mm; CMT and WMT based on climate station 83381 (Irai)
Methods
Life forms: butterflies
Sampling methods: no design,butterfly nets
Sample size: 726 captures or sightings
Years: 2006, 2007
Sampling comments: "In each sampling, three active nets were settled from 9:00 h to 14:00 h"; the nets are described as "standard entomological" and no further information is given
Metadata
Sample number: 985
Contributor: John Alroy
Enterer: John Alroy
Created: 2014-06-30 16:37:53
Modified: 2015-02-23 23:47:39
Abundance distribution
127 species
43 singletons
total count 726
extrapolated richness: 254.1
Fisher's α: 44.556
geometric series k: 0.9688
Hurlbert's PIE: 0.9771
Shannon's H: 4.2230
Good's u: 0.9408
Each square represents a species. Square sizes are proportional to counts.