Coordinate: 5° 35' N, 116° 5' E
elevation 400 to 800 m
climate data are for "six miles south west of Keningau Town" and are from Kong (1962, Indo-Pacific Fish. Council Proc.)
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=2117 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2117SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2130SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2117 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chilasa' AND (junior_species='slateri' OR junior_species='slaterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chilasa' AND (species='slateri' OR species='slaterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chilasa' AND (species='slateri' OR species='slaterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chilasa' AND (junior_species='slateri' OR junior_species='slaterii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chilasa' AND (species='slateri' OR species='slaterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='agamemnon' OR junior_species='agamemnon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphium' AND (species='agamemnon' OR species='agamemnon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphium' AND (species='agamemnon' OR species='agamemnon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='agamemnon' OR junior_species='agamemnon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Graphium' AND (species='agamemnon' OR species='agamemnon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='bathycles' OR junior_species='bathycles')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphium' AND (species='bathycles' OR species='bathycles') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphium' AND (species='bathycles' OR species='bathycles')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='bathycles' OR junior_species='bathycles')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Graphium' AND (species='bathycles' OR species='bathycles') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='doson' OR junior_species='doson')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphium' AND (species='doson' OR species='doson') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphium' AND (species='doson' OR species='doson')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='doson' OR junior_species='doson')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Graphium' AND (species='doson' OR species='doson') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='euryplus' OR junior_species='euryplus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphium' AND (species='euryplus' OR species='euryplus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphium' AND (species='euryplus' OR species='euryplus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='euryplus' OR junior_species='euryplus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Graphium' AND (species='euryplus' OR species='euryplus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='evemon' OR junior_species='evemon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphium' AND (species='evemon' OR species='evemon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphium' AND (species='evemon' OR species='evemon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='evemon' OR junior_species='evemon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Graphium' AND (species='evemon' OR species='evemon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='sarpedon' OR junior_species='sarpedon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphium' AND (species='sarpedon' OR species='sarpedon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphium' AND (species='sarpedon' OR species='sarpedon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='sarpedon' OR junior_species='sarpedon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Graphium' AND (species='sarpedon' OR species='sarpedon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamproptera' AND (junior_species='meges' OR junior_species='meges')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lamproptera' AND (species='meges' OR species='meges') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lamproptera' AND (species='meges' OR species='meges')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamproptera' AND (junior_species='meges' OR junior_species='meges')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lamproptera' AND (species='meges' OR species='meges') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamproptera' AND (junior_species='curius' OR junior_species='curius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lamproptera' AND (species='curius' OR species='curius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lamproptera' AND (species='curius' OR species='curius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamproptera' AND (junior_species='curius' OR junior_species='curius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lamproptera' AND (species='curius' OR species='curius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='demolion' OR junior_species='demolion')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='demolion' OR species='demolion') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='demolion' OR species='demolion')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='demolion' OR junior_species='demolion')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Papilio' AND (species='demolion' OR species='demolion') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='helenus' OR junior_species='helenus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='helenus' OR species='helenus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='helenus' OR species='helenus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='helenus' OR junior_species='helenus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Papilio' AND (species='helenus' OR species='helenus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='memnon' OR junior_species='memnon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='memnon' OR species='memnon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='memnon' OR species='memnon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='memnon' OR junior_species='memnon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Papilio' AND (species='memnon' OR species='memnon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trogonoptera' AND (junior_species='brookiana' OR junior_species='brookiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trogonoptera' AND (species='brookiana' OR species='brookiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trogonoptera' AND (species='brookiana' OR species='brookiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trogonoptera' AND (junior_species='brookiana' OR junior_species='brookiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trogonoptera' AND (species='brookiana' OR species='brookiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Appias' AND (junior_species='lyncida' OR junior_species='lyncida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Appias' AND (species='lyncida' OR species='lyncida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Appias' AND (species='lyncida' OR species='lyncida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Appias' AND (junior_species='lyncida' OR junior_species='lyncida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Appias' AND (species='lyncida' OR species='lyncida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Appias' AND (junior_species='nero' OR junior_species='nero')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Appias' AND (species='nero' OR species='nero') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Appias' AND (species='nero' OR species='nero')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Appias' AND (junior_species='nero' OR junior_species='nero')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Appias' AND (species='nero' OR species='nero') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Captosilia' AND (junior_species='pyranthe' OR junior_species='pyranthe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Captosilia' AND (species='pyranthe' OR species='pyranthe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Captosilia' AND (species='pyranthe' OR species='pyranthe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Captosilia' AND (junior_species='pyranthe' OR junior_species='pyranthe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Captosilia' AND (species='pyranthe' OR species='pyranthe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Captosiila' AND (junior_species='pomona' OR junior_species='pomona')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Captosiila' AND (species='pomona' OR species='pomona') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Captosiila' AND (species='pomona' OR species='pomona')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Captosiila' AND (junior_species='pomona' OR junior_species='pomona')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Captosiila' AND (species='pomona' OR species='pomona') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cepora' AND (junior_species='iudith' OR junior_species='iudith')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cepora' AND (species='iudith' OR species='iudith') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cepora' AND (species='iudith' OR species='iudith')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cepora' AND (junior_species='iudith' OR junior_species='iudith')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cepora' AND (species='iudith' OR species='iudith') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cepora' AND (junior_species='pactolicus' OR junior_species='pactolicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cepora' AND (species='pactolicus' OR species='pactolicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cepora' AND (species='pactolicus' OR species='pactolicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cepora' AND (junior_species='pactolicus' OR junior_species='pactolicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cepora' AND (species='pactolicus' OR species='pactolicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='andersonii' OR junior_species='andersoni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='andersonii' OR species='andersoni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='andersonii' OR species='andersoni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='andersonii' OR junior_species='andersoni')SELECT d.diet,d.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='andersonii' OR species='andersoni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='blanda' OR junior_species='blanda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='blanda' OR species='blanda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='blanda' OR species='blanda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='blanda' OR junior_species='blanda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eurema' AND (species='blanda' OR species='blanda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='hecabe' OR junior_species='hecabe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='hecabe' OR species='hecabe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='hecabe' OR species='hecabe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='hecabe' OR junior_species='hecabe')SELECT d.diet,d.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='hecabe' OR species='hecabe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='nicevillei' OR junior_species='nicevilleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='nicevillei' OR species='nicevilleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='nicevillei' OR species='nicevilleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='nicevillei' OR junior_species='nicevilleii')SELECT d.diet,d.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='nicevillei' OR species='nicevilleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='simulatrix' OR junior_species='simulatrix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='simulatrix' OR species='simulatrix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='simulatrix' OR species='simulatrix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='simulatrix' OR junior_species='simulatrix')SELECT d.diet,d.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='simulatrix' OR species='simulatrix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gandaca' AND (junior_species='harina' OR junior_species='harina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gandaca' AND (species='harina' OR species='harina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gandaca' AND (species='harina' OR species='harina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gandaca' AND (junior_species='harina' OR junior_species='harina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gandaca' AND (species='harina' OR species='harina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hebomoia' AND (junior_species='glaucippe' OR junior_species='glaucippe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hebomoia' AND (species='glaucippe' OR species='glaucippe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hebomoia' AND (species='glaucippe' OR species='glaucippe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hebomoia' AND (junior_species='glaucippe' OR junior_species='glaucippe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hebomoia' AND (species='glaucippe' OR species='glaucippe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ixias' AND (junior_species='undatus' OR junior_species='undatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ixias' AND (species='undatus' OR species='undatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ixias' AND (species='undatus' OR species='undatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ixias' AND (junior_species='undatus' OR junior_species='undatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ixias' AND (species='undatus' OR species='undatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptosia' AND (junior_species='nina' OR junior_species='nina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptosia' AND (species='nina' OR species='nina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptosia' AND (species='nina' OR species='nina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptosia' AND (junior_species='nina' OR junior_species='nina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptosia' AND (species='nina' OR species='nina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareronia' AND (junior_species='valeria' OR junior_species='valeria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pareronia' AND (species='valeria' OR species='valeria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pareronia' AND (species='valeria' OR species='valeria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareronia' AND (junior_species='valeria' OR junior_species='valeria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pareronia' AND (species='valeria' OR species='valeria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Priocneris' AND (junior_species='cornelia' OR junior_species='cornelia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Priocneris' AND (species='cornelia' OR species='cornelia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Priocneris' AND (species='cornelia' OR species='cornelia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Priocneris' AND (junior_species='cornelia' OR junior_species='cornelia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Priocneris' AND (species='cornelia' OR species='cornelia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parantica' AND (junior_species='aspasia' OR junior_species='aspasia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parantica' AND (species='aspasia' OR species='aspasia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parantica' AND (species='aspasia' OR species='aspasia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parantica' AND (junior_species='aspasia' OR junior_species='aspasia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parantica' AND (species='aspasia' OR species='aspasia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anosia' AND (junior_species='genuitia' OR junior_species='genuitia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anosia' AND (species='genuitia' OR species='genuitia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anosia' AND (species='genuitia' OR species='genuitia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anosia' AND (junior_species='genuitia' OR junior_species='genuitia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anosia' AND (species='genuitia' OR species='genuitia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anosia' AND (junior_species='melanippus' OR junior_species='melanippus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anosia' AND (species='melanippus' OR species='melanippus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anosia' AND (species='melanippus' OR species='melanippus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anosia' AND (junior_species='melanippus' OR junior_species='melanippus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anosia' AND (species='melanippus' OR species='melanippus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tirumala' AND (junior_species='septentrionis' OR junior_species='septentrionis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tirumala' AND (species='septentrionis' OR species='septentrionis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tirumala' AND (species='septentrionis' OR species='septentrionis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tirumala' AND (junior_species='septentrionis' OR junior_species='septentrionis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tirumala' AND (species='septentrionis' OR species='septentrionis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='crameri' OR junior_species='cramerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euploea' AND (species='crameri' OR species='cramerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euploea' AND (species='crameri' OR species='cramerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='crameri' OR junior_species='cramerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euploea' AND (species='crameri' OR species='cramerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='mulciber' OR junior_species='mulciber')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euploea' AND (species='mulciber' OR species='mulciber') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euploea' AND (species='mulciber' OR species='mulciber')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='mulciber' OR junior_species='mulciber')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euploea' AND (species='mulciber' OR species='mulciber') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='phaenareta' OR junior_species='phaenareta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euploea' AND (species='phaenareta' OR species='phaenareta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euploea' AND (species='phaenareta' OR species='phaenareta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='phaenareta' OR junior_species='phaenareta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euploea' AND (species='phaenareta' OR species='phaenareta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='tulliolus' OR junior_species='tulliolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euploea' AND (species='tulliolus' OR species='tulliolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euploea' AND (species='tulliolus' OR species='tulliolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='tulliolus' OR junior_species='tulliolus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euploea' AND (species='tulliolus' OR species='tulliolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ideopsis' AND (junior_species='vulgaris' OR junior_species='vulgaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ideopsis' AND (species='vulgaris' OR species='vulgaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ideopsis' AND (species='vulgaris' OR species='vulgaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ideopsis' AND (junior_species='vulgaris' OR junior_species='vulgaris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ideopsis' AND (species='vulgaris' OR species='vulgaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discophora' AND (junior_species='necho' OR junior_species='necho')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Discophora' AND (species='necho' OR species='necho') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Discophora' AND (species='necho' OR species='necho')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discophora' AND (junior_species='necho' OR junior_species='necho')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Discophora' AND (species='necho' OR species='necho') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erites' AND (junior_species='elegans' OR junior_species='elegans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erites' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erites' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erites' AND (junior_species='elegans' OR junior_species='elegans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erites' AND (species='elegans' OR species='elegans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Faunis' AND (junior_species='gracilis' OR junior_species='gracilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Faunis' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Faunis' AND (species='gracilis' OR species='gracilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Faunis' AND (junior_species='gracilis' OR junior_species='gracilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Faunis' AND (species='gracilis' OR species='gracilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Faunis' AND (junior_species='stomphax' OR junior_species='stomphax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Faunis' AND (species='stomphax' OR species='stomphax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Faunis' AND (species='stomphax' OR species='stomphax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Faunis' AND (junior_species='stomphax' OR junior_species='stomphax')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Faunis' AND (species='stomphax' OR species='stomphax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melantis' AND (junior_species='leda' OR junior_species='leda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melantis' AND (species='leda' OR species='leda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melantis' AND (species='leda' OR species='leda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melantis' AND (junior_species='leda' OR junior_species='leda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melantis' AND (species='leda' OR species='leda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='anapita' OR junior_species='anapita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='anapita' OR species='anapita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='anapita' OR species='anapita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='anapita' OR junior_species='anapita')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='anapita' OR species='anapita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='fusca' OR junior_species='fusca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='fusca' OR junior_species='fusca')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='fusca' OR species='fusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='horsfieldi' OR junior_species='horsfieldii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='horsfieldi' OR species='horsfieldii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='horsfieldi' OR species='horsfieldii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='horsfieldi' OR junior_species='horsfieldii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='horsfieldi' OR species='horsfieldii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='janardana' OR junior_species='janardana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='janardana' OR species='janardana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='janardana' OR species='janardana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='janardana' OR junior_species='janardana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='janardana' OR species='janardana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='mineus' OR junior_species='mineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='mineus' OR species='mineus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='mineus' OR species='mineus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='mineus' OR junior_species='mineus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='mineus' OR species='mineus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='orseis' OR junior_species='orseis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='orseis' OR species='orseis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='orseis' OR species='orseis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='orseis' OR junior_species='orseis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='orseis' OR species='orseis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neorina' AND (junior_species='lowii' OR junior_species='lowi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neorina' AND (species='lowii' OR species='lowi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neorina' AND (species='lowii' OR species='lowi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neorina' AND (junior_species='lowii' OR junior_species='lowi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neorina' AND (species='lowii' OR species='lowi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ragadia' AND (junior_species='makuta' OR junior_species='makuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ragadia' AND (species='makuta' OR species='makuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ragadia' AND (species='makuta' OR species='makuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ragadia' AND (junior_species='makuta' OR junior_species='makuta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ragadia' AND (species='makuta' OR species='makuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thaumantis' AND (junior_species='klugius' OR junior_species='klugius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thaumantis' AND (species='klugius' OR species='klugius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thaumantis' AND (species='klugius' OR species='klugius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thaumantis' AND (junior_species='klugius' OR junior_species='klugius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thaumantis' AND (species='klugius' OR species='klugius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thauria' AND (junior_species='aliris' OR junior_species='aliris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thauria' AND (species='aliris' OR species='aliris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thauria' AND (species='aliris' OR species='aliris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thauria' AND (junior_species='aliris' OR junior_species='aliris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thauria' AND (species='aliris' OR species='aliris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthotaenia' AND (junior_species='busiris' OR junior_species='busiris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthotaenia' AND (species='busiris' OR species='busiris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthotaenia' AND (species='busiris' OR species='busiris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthotaenia' AND (junior_species='busiris' OR junior_species='busiris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xanthotaenia' AND (species='busiris' OR species='busiris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='baldus' OR junior_species='baldus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ypthima' AND (species='baldus' OR species='baldus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ypthima' AND (species='baldus' OR species='baldus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='baldus' OR junior_species='baldus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ypthima' AND (species='baldus' OR species='baldus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='fasciata' OR junior_species='fasciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ypthima' AND (species='fasciata' OR species='fasciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ypthima' AND (species='fasciata' OR species='fasciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='fasciata' OR junior_species='fasciata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ypthima' AND (species='fasciata' OR species='fasciata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='pandocus' OR junior_species='pandocus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ypthima' AND (species='pandocus' OR species='pandocus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ypthima' AND (species='pandocus' OR species='pandocus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='pandocus' OR junior_species='pandocus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ypthima' AND (species='pandocus' OR species='pandocus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='assa' OR junior_species='assa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Athyma' AND (species='assa' OR species='assa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Athyma' AND (species='assa' OR species='assa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='assa' OR junior_species='assa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Athyma' AND (species='assa' OR species='assa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bassarona' AND (junior_species='dunya' OR junior_species='dunya')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bassarona' AND (species='dunya' OR species='dunya') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bassarona' AND (species='dunya' OR species='dunya')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bassarona' AND (junior_species='dunya' OR junior_species='dunya')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bassarona' AND (species='dunya' OR species='dunya') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='bernadus' OR junior_species='bernadus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='bernadus' OR species='bernadus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='bernadus' OR species='bernadus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='bernadus' OR junior_species='bernadus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Charaxes' AND (species='bernadus' OR species='bernadus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chersonesia' AND (junior_species='rahria' OR junior_species='rahria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chersonesia' AND (species='rahria' OR species='rahria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chersonesia' AND (species='rahria' OR species='rahria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chersonesia' AND (junior_species='rahria' OR junior_species='rahria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chersonesia' AND (species='rahria' OR species='rahria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupha' AND (junior_species='erymanthis' OR junior_species='erymanthis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cupha' AND (species='erymanthis' OR species='erymanthis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cupha' AND (species='erymanthis' OR species='erymanthis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupha' AND (junior_species='erymanthis' OR junior_species='erymanthis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cupha' AND (species='erymanthis' OR species='erymanthis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyrestis' AND (junior_species='nivea' OR junior_species='nivea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyrestis' AND (species='nivea' OR species='nivea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyrestis' AND (species='nivea' OR species='nivea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyrestis' AND (junior_species='nivea' OR junior_species='nivea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyrestis' AND (species='nivea' OR species='nivea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doleschallia' AND (junior_species='bisaltide' OR junior_species='bisaltide')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Doleschallia' AND (species='bisaltide' OR species='bisaltide') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Doleschallia' AND (species='bisaltide' OR species='bisaltide')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doleschallia' AND (junior_species='bisaltide' OR junior_species='bisaltide')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Doleschallia' AND (species='bisaltide' OR species='bisaltide') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dophla' AND (junior_species='evelina' OR junior_species='evelina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dophla' AND (species='evelina' OR species='evelina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dophla' AND (species='evelina' OR species='evelina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dophla' AND (junior_species='evelina' OR junior_species='evelina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dophla' AND (species='evelina' OR species='evelina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euripus' AND (junior_species='nyctelius' OR junior_species='nyctelius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euripus' AND (species='nyctelius' OR species='nyctelius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euripus' AND (species='nyctelius' OR species='nyctelius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euripus' AND (junior_species='nyctelius' OR junior_species='nyctelius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euripus' AND (species='nyctelius' OR species='nyctelius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euthalia' AND (junior_species='iapis' OR junior_species='iapis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euthalia' AND (species='iapis' OR species='iapis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euthalia' AND (species='iapis' OR species='iapis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euthalia' AND (junior_species='iapis' OR junior_species='iapis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euthalia' AND (species='iapis' OR species='iapis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolimnas' AND (junior_species='anomala' OR junior_species='anomala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypolimnas' AND (species='anomala' OR species='anomala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypolimnas' AND (species='anomala' OR species='anomala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolimnas' AND (junior_species='anomala' OR junior_species='anomala')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypolimnas' AND (species='anomala' OR species='anomala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolimnas' AND (junior_species='bolina' OR junior_species='bolina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypolimnas' AND (species='bolina' OR species='bolina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypolimnas' AND (species='bolina' OR species='bolina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolimnas' AND (junior_species='bolina' OR junior_species='bolina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypolimnas' AND (species='bolina' OR species='bolina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='almana' OR junior_species='almana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='almana' OR species='almana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='almana' OR species='almana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='almana' OR junior_species='almana')SELECT d.diet,d.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='almana' OR species='almana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='atlites' OR junior_species='atlites')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='atlites' OR species='atlites') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='atlites' OR species='atlites')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='atlites' OR junior_species='atlites')SELECT d.diet,d.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='atlites' OR species='atlites') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='hedonia' OR junior_species='hedonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='hedonia' OR species='hedonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='hedonia' OR species='hedonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='hedonia' OR junior_species='hedonia')SELECT d.diet,d.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='hedonia' OR species='hedonia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='iphita' OR junior_species='iphita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='iphita' OR species='iphita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='iphita' OR species='iphita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='iphita' OR junior_species='iphita')SELECT d.diet,d.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='iphita' OR species='iphita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lebadea' AND (junior_species='martha' OR junior_species='martha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lebadea' AND (species='martha' OR species='martha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lebadea' AND (species='martha' OR species='martha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lebadea' AND (junior_species='martha' OR junior_species='martha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lebadea' AND (species='martha' OR species='martha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moduza' AND (junior_species='procris' OR junior_species='procris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Moduza' AND (species='procris' OR species='procris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moduza' AND (species='procris' OR species='procris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moduza' AND (junior_species='procris' OR junior_species='procris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Moduza' AND (species='procris' OR species='procris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='clinia' OR junior_species='clinia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='clinia' OR species='clinia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='clinia' OR species='clinia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='clinia' OR junior_species='clinia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neptis' AND (species='clinia' OR species='clinia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='hylas' OR junior_species='hylas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='hylas' OR species='hylas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='hylas' OR species='hylas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='hylas' OR junior_species='hylas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neptis' AND (species='hylas' OR species='hylas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parthenos' AND (junior_species='sylvia' OR junior_species='sylvia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parthenos' AND (species='sylvia' OR species='sylvia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parthenos' AND (species='sylvia' OR species='sylvia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parthenos' AND (junior_species='sylvia' OR junior_species='sylvia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parthenos' AND (species='sylvia' OR species='sylvia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyura' AND (junior_species='athamas' OR junior_species='athamas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyura' AND (species='athamas' OR species='athamas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyura' AND (species='athamas' OR species='athamas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyura' AND (junior_species='athamas' OR junior_species='athamas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polyura' AND (species='athamas' OR species='athamas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyura' AND (junior_species='moori' OR junior_species='moorii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyura' AND (species='moori' OR species='moorii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyura' AND (species='moori' OR species='moorii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyura' AND (junior_species='moori' OR junior_species='moorii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polyura' AND (species='moori' OR species='moorii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tanaecia' AND (junior_species='pelea' OR junior_species='pelea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tanaecia' AND (species='pelea' OR species='pelea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tanaecia' AND (species='pelea' OR species='pelea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tanaecia' AND (junior_species='pelea' OR junior_species='pelea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tanaecia' AND (species='pelea' OR species='pelea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terinos' AND (junior_species='atlita' OR junior_species='atlita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terinos' AND (species='atlita' OR species='atlita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terinos' AND (species='atlita' OR species='atlita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terinos' AND (junior_species='atlita' OR junior_species='atlita')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Terinos' AND (species='atlita' OR species='atlita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vindula' AND (junior_species='erota' OR junior_species='erota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vindula' AND (species='erota' OR species='erota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vindula' AND (species='erota' OR species='erota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vindula' AND (junior_species='erota' OR junior_species='erota')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vindula' AND (species='erota' OR species='erota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zemeros' AND (junior_species='emesoides' OR junior_species='emesoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zemeros' AND (species='emesoides' OR species='emesoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zemeros' AND (species='emesoides' OR species='emesoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zemeros' AND (junior_species='emesoides' OR junior_species='emesoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zemeros' AND (species='emesoides' OR species='emesoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allotinus' AND (junior_species='bidiensis' OR junior_species='bidiensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allotinus' AND (species='bidiensis' OR species='bidiensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allotinus' AND (species='bidiensis' OR species='bidiensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allotinus' AND (junior_species='bidiensis' OR junior_species='bidiensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Allotinus' AND (species='bidiensis' OR species='bidiensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allotinus' AND (junior_species='horsfieldi' OR junior_species='horsfieldii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allotinus' AND (species='horsfieldi' OR species='horsfieldii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allotinus' AND (species='horsfieldi' OR species='horsfieldii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allotinus' AND (junior_species='horsfieldi' OR junior_species='horsfieldii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Allotinus' AND (species='horsfieldi' OR species='horsfieldii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arophala' AND (junior_species='pseudocentaurus' OR junior_species='pseudocentaurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arophala' AND (species='pseudocentaurus' OR species='pseudocentaurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arophala' AND (species='pseudocentaurus' OR species='pseudocentaurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arophala' AND (junior_species='pseudocentaurus' OR junior_species='pseudocentaurus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arophala' AND (species='pseudocentaurus' OR species='pseudocentaurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arophala' AND (junior_species='epimuta' OR junior_species='epimuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arophala' AND (species='epimuta' OR species='epimuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arophala' AND (species='epimuta' OR species='epimuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arophala' AND (junior_species='epimuta' OR junior_species='epimuta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arophala' AND (species='epimuta' OR species='epimuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arophala' AND (junior_species='fulla' OR junior_species='fulla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arophala' AND (species='fulla' OR species='fulla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arophala' AND (species='fulla' OR species='fulla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arophala' AND (junior_species='fulla' OR junior_species='fulla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arophala' AND (species='fulla' OR species='fulla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caleta' AND (junior_species='manovus' OR junior_species='manovus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caleta' AND (species='manovus' OR species='manovus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caleta' AND (species='manovus' OR species='manovus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caleta' AND (junior_species='manovus' OR junior_species='manovus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Caleta' AND (species='manovus' OR species='manovus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catochrysops' AND (junior_species='panormus' OR junior_species='panormus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catochrysops' AND (species='panormus' OR species='panormus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catochrysops' AND (species='panormus' OR species='panormus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catochrysops' AND (junior_species='panormus' OR junior_species='panormus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catochrysops' AND (species='panormus' OR species='panormus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celastrina' AND (junior_species='lavendularis' OR junior_species='lavendularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celastrina' AND (species='lavendularis' OR species='lavendularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celastrina' AND (species='lavendularis' OR species='lavendularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celastrina' AND (junior_species='lavendularis' OR junior_species='lavendularis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Celastrina' AND (species='lavendularis' OR species='lavendularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Curetis' AND (junior_species='santana' OR junior_species='santana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Curetis' AND (species='santana' OR species='santana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Curetis' AND (species='santana' OR species='santana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Curetis' AND (junior_species='santana' OR junior_species='santana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Curetis' AND (species='santana' OR species='santana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Curetis' AND (junior_species='sperthis' OR junior_species='sperthis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Curetis' AND (species='sperthis' OR species='sperthis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Curetis' AND (species='sperthis' OR species='sperthis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Curetis' AND (junior_species='sperthis' OR junior_species='sperthis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Curetis' AND (species='sperthis' OR species='sperthis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Curetis' AND (junior_species='tagalica' OR junior_species='tagalica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Curetis' AND (species='tagalica' OR species='tagalica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Curetis' AND (species='tagalica' OR species='tagalica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Curetis' AND (junior_species='tagalica' OR junior_species='tagalica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Curetis' AND (species='tagalica' OR species='tagalica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drupadia' AND (junior_species='ravindra' OR junior_species='ravindra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drupadia' AND (species='ravindra' OR species='ravindra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drupadia' AND (species='ravindra' OR species='ravindra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drupadia' AND (junior_species='ravindra' OR junior_species='ravindra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Drupadia' AND (species='ravindra' OR species='ravindra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euchrysops' AND (junior_species='cnejus' OR junior_species='cnejus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euchrysops' AND (species='cnejus' OR species='cnejus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euchrysops' AND (species='cnejus' OR species='cnejus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euchrysops' AND (junior_species='cnejus' OR junior_species='cnejus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euchrysops' AND (species='cnejus' OR species='cnejus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eooxylides' AND (junior_species='tharis' OR junior_species='tharis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eooxylides' AND (species='tharis' OR species='tharis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eooxylides' AND (species='tharis' OR species='tharis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eooxylides' AND (junior_species='tharis' OR junior_species='tharis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eooxylides' AND (species='tharis' OR species='tharis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipolycaea' AND (junior_species='othona' OR junior_species='othona')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipolycaea' AND (species='othona' OR species='othona') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hipolycaea' AND (species='othona' OR species='othona')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipolycaea' AND (junior_species='othona' OR junior_species='othona')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hipolycaea' AND (species='othona' OR species='othona') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ionolyce' AND (junior_species='helicon' OR junior_species='helicon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ionolyce' AND (species='helicon' OR species='helicon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ionolyce' AND (species='helicon' OR species='helicon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ionolyce' AND (junior_species='helicon' OR junior_species='helicon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ionolyce' AND (species='helicon' OR species='helicon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='aratus' OR junior_species='aratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jamides' AND (species='aratus' OR species='aratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jamides' AND (species='aratus' OR species='aratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='aratus' OR junior_species='aratus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Jamides' AND (species='aratus' OR species='aratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='caeruleus' OR junior_species='caeruleus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jamides' AND (species='caeruleus' OR species='caeruleus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jamides' AND (species='caeruleus' OR species='caeruleus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='caeruleus' OR junior_species='caeruleus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Jamides' AND (species='caeruleus' OR species='caeruleus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='celeno' OR junior_species='celeno')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jamides' AND (species='celeno' OR species='celeno') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jamides' AND (species='celeno' OR species='celeno')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='celeno' OR junior_species='celeno')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Jamides' AND (species='celeno' OR species='celeno') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='pura' OR junior_species='pura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jamides' AND (species='pura' OR species='pura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jamides' AND (species='pura' OR species='pura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='pura' OR junior_species='pura')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Jamides' AND (species='pura' OR species='pura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampides' AND (junior_species='boeticus' OR junior_species='boeticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lampides' AND (species='boeticus' OR species='boeticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lampides' AND (species='boeticus' OR species='boeticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampides' AND (junior_species='boeticus' OR junior_species='boeticus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lampides' AND (species='boeticus' OR species='boeticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manto' AND (junior_species='hypoleuca' OR junior_species='hypoleuca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Manto' AND (species='hypoleuca' OR species='hypoleuca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Manto' AND (species='hypoleuca' OR species='hypoleuca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manto' AND (junior_species='hypoleuca' OR junior_species='hypoleuca')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Manto' AND (species='hypoleuca' OR species='hypoleuca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miletus' AND (junior_species='cellarius' OR junior_species='cellarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miletus' AND (species='cellarius' OR species='cellarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miletus' AND (species='cellarius' OR species='cellarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miletus' AND (junior_species='cellarius' OR junior_species='cellarius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Miletus' AND (species='cellarius' OR species='cellarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miletus' AND (junior_species='symethus' OR junior_species='symethus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miletus' AND (species='symethus' OR species='symethus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miletus' AND (species='symethus' OR species='symethus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miletus' AND (junior_species='symethus' OR junior_species='symethus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Miletus' AND (species='symethus' OR species='symethus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nacaduba' AND (junior_species='berenice' OR junior_species='berenice')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nacaduba' AND (species='berenice' OR species='berenice') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nacaduba' AND (species='berenice' OR species='berenice')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nacaduba' AND (junior_species='berenice' OR junior_species='berenice')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nacaduba' AND (species='berenice' OR species='berenice') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nacaduba' AND (junior_species='hermus' OR junior_species='hermus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nacaduba' AND (species='hermus' OR species='hermus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nacaduba' AND (species='hermus' OR species='hermus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nacaduba' AND (junior_species='hermus' OR junior_species='hermus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nacaduba' AND (species='hermus' OR species='hermus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nacaduba' AND (junior_species='russelli' OR junior_species='russellii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nacaduba' AND (species='russelli' OR species='russellii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nacaduba' AND (species='russelli' OR species='russellii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nacaduba' AND (junior_species='russelli' OR junior_species='russellii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nacaduba' AND (species='russelli' OR species='russellii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nacaduba' AND (junior_species='subperusia' OR junior_species='subperusia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nacaduba' AND (species='subperusia' OR species='subperusia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nacaduba' AND (species='subperusia' OR species='subperusia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nacaduba' AND (junior_species='subperusia' OR junior_species='subperusia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nacaduba' AND (species='subperusia' OR species='subperusia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prosotas' AND (junior_species='nora' OR junior_species='nora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prosotas' AND (species='nora' OR species='nora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prosotas' AND (species='nora' OR species='nora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prosotas' AND (junior_species='nora' OR junior_species='nora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prosotas' AND (species='nora' OR species='nora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prosotas' AND (junior_species='aluta' OR junior_species='aluta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prosotas' AND (species='aluta' OR species='aluta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prosotas' AND (species='aluta' OR species='aluta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prosotas' AND (junior_species='aluta' OR junior_species='aluta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prosotas' AND (species='aluta' OR species='aluta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spalgis' AND (junior_species='epius' OR junior_species='epius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spalgis' AND (species='epius' OR species='epius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spalgis' AND (species='epius' OR species='epius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spalgis' AND (junior_species='epius' OR junior_species='epius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Spalgis' AND (species='epius' OR species='epius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizula' AND (junior_species='hylax' OR junior_species='hylax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zizula' AND (species='hylax' OR species='hylax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zizula' AND (species='hylax' OR species='hylax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizula' AND (junior_species='hylax' OR junior_species='hylax')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zizula' AND (species='hylax' OR species='hylax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anacistroides' AND (junior_species='nigrita' OR junior_species='nigrita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anacistroides' AND (species='nigrita' OR species='nigrita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anacistroides' AND (species='nigrita' OR species='nigrita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anacistroides' AND (junior_species='nigrita' OR junior_species='nigrita')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anacistroides' AND (species='nigrita' OR species='nigrita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baoris' AND (junior_species='oceia' OR junior_species='oceia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Baoris' AND (species='oceia' OR species='oceia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Baoris' AND (species='oceia' OR species='oceia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baoris' AND (junior_species='oceia' OR junior_species='oceia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Baoris' AND (species='oceia' OR species='oceia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bibasis' AND (junior_species='sena' OR junior_species='sena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bibasis' AND (species='sena' OR species='sena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bibasis' AND (species='sena' OR species='sena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bibasis' AND (junior_species='sena' OR junior_species='sena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bibasis' AND (species='sena' OR species='sena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halpes' AND (junior_species='ormenes' OR junior_species='ormenes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Halpes' AND (species='ormenes' OR species='ormenes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halpes' AND (species='ormenes' OR species='ormenes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halpes' AND (junior_species='ormenes' OR junior_species='ormenes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Halpes' AND (species='ormenes' OR species='ormenes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halpe' AND (junior_species='pelethronix' OR junior_species='pelethronix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Halpe' AND (species='pelethronix' OR species='pelethronix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halpe' AND (species='pelethronix' OR species='pelethronix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halpe' AND (junior_species='pelethronix' OR junior_species='pelethronix')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Halpe' AND (species='pelethronix' OR species='pelethronix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iambrix' AND (junior_species='stellifer' OR junior_species='stellifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Iambrix' AND (species='stellifer' OR species='stellifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Iambrix' AND (species='stellifer' OR species='stellifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iambrix' AND (junior_species='stellifer' OR junior_species='stellifer')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Iambrix' AND (species='stellifer' OR species='stellifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iton' AND (junior_species='semamora' OR junior_species='semamora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Iton' AND (species='semamora' OR species='semamora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Iton' AND (species='semamora' OR species='semamora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iton' AND (junior_species='semamora' OR junior_species='semamora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Iton' AND (species='semamora' OR species='semamora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Koruthaialos' AND (junior_species='rubecula' OR junior_species='rubecula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Koruthaialos' AND (species='rubecula' OR species='rubecula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Koruthaialos' AND (species='rubecula' OR species='rubecula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Koruthaialos' AND (junior_species='rubecula' OR junior_species='rubecula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Koruthaialos' AND (species='rubecula' OR species='rubecula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Matapa' AND (junior_species='druna' OR junior_species='druna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Matapa' AND (species='druna' OR species='druna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Matapa' AND (species='druna' OR species='druna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Matapa' AND (junior_species='druna' OR junior_species='druna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Matapa' AND (species='druna' OR species='druna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oriens' AND (junior_species='gora' OR junior_species='gora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oriens' AND (species='gora' OR species='gora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oriens' AND (species='gora' OR species='gora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oriens' AND (junior_species='gora' OR junior_species='gora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oriens' AND (species='gora' OR species='gora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelopidas' AND (junior_species='conjunctus' OR junior_species='conjunctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pelopidas' AND (species='conjunctus' OR species='conjunctus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pelopidas' AND (species='conjunctus' OR species='conjunctus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelopidas' AND (junior_species='conjunctus' OR junior_species='conjunctus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pelopidas' AND (species='conjunctus' OR species='conjunctus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potanthus' AND (junior_species='ganda' OR junior_species='ganda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Potanthus' AND (species='ganda' OR species='ganda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Potanthus' AND (species='ganda' OR species='ganda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potanthus' AND (junior_species='ganda' OR junior_species='ganda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Potanthus' AND (species='ganda' OR species='ganda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudocoladenia' AND (junior_species='dan' OR junior_species='dan')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudocoladenia' AND (species='dan' OR species='dan') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudocoladenia' AND (species='dan' OR species='dan')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudocoladenia' AND (junior_species='dan' OR junior_species='dan')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudocoladenia' AND (species='dan' OR species='dan') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psolos' AND (junior_species='fuligo' OR junior_species='fuligo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psolos' AND (species='fuligo' OR species='fuligo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psolos' AND (species='fuligo' OR species='fuligo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psolos' AND (junior_species='fuligo' OR junior_species='fuligo')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Psolos' AND (species='fuligo' OR species='fuligo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tagiades' AND (junior_species='gana' OR junior_species='gana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tagiades' AND (species='gana' OR species='gana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tagiades' AND (species='gana' OR species='gana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tagiades' AND (junior_species='gana' OR junior_species='gana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tagiades' AND (species='gana' OR species='gana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tagiades' AND (junior_species='japetus' OR junior_species='japetus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tagiades' AND (species='japetus' OR species='japetus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tagiades' AND (species='japetus' OR species='japetus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tagiades' AND (junior_species='japetus' OR junior_species='japetus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tagiades' AND (species='japetus' OR species='japetus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2117