Coordinate: 21° 58' N, 104° 2' E
climate data are for the Van Ban Nature Reserve and are from Lam and Mai (2013, in Sunderland et al.)
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=2304 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2304SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2247SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2304 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troides' AND (junior_species='aeacus' OR junior_species='aeacus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Troides' AND (species='aeacus' OR species='aeacus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Troides' AND (species='aeacus' OR species='aeacus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troides' AND (junior_species='aeacus' OR junior_species='aeacus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Troides' AND (species='aeacus' OR species='aeacus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chilasa' AND (junior_species='agestor' OR junior_species='agestor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chilasa' AND (species='agestor' OR species='agestor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chilasa' AND (species='agestor' OR species='agestor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chilasa' AND (junior_species='agestor' OR junior_species='agestor')SELECT d.diet,d.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='agestor' OR species='agestor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chilasa' AND (junior_species='epycides' OR junior_species='epycides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chilasa' AND (species='epycides' OR species='epycides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chilasa' AND (species='epycides' OR species='epycides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chilasa' AND (junior_species='epycides' OR junior_species='epycides')SELECT d.diet,d.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='epycides' OR species='epycides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chilasa' AND (junior_species='paradoxa' OR junior_species='paradoxa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chilasa' AND (species='paradoxa' OR species='paradoxa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chilasa' AND (species='paradoxa' OR species='paradoxa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chilasa' AND (junior_species='paradoxa' OR junior_species='paradoxa')SELECT d.diet,d.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='paradoxa' OR species='paradoxa') 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='nephelus' OR junior_species='nephelus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='nephelus' OR species='nephelus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='nephelus' OR species='nephelus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='nephelus' OR junior_species='nephelus')SELECT d.diet,d.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='nephelus' OR species='nephelus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='polytes' OR junior_species='polytes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='polytes' OR species='polytes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='polytes' OR species='polytes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='polytes' OR junior_species='polytes')SELECT d.diet,d.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='polytes' OR species='polytes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='paris' OR junior_species='paris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='paris' OR species='paris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='paris' OR species='paris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='paris' OR junior_species='paris')SELECT d.diet,d.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='paris' OR species='paris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='bianor' OR junior_species='bianor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='bianor' OR species='bianor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='bianor' OR species='bianor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='bianor' OR junior_species='bianor')SELECT d.diet,d.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='bianor' OR species='bianor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='protenor' OR junior_species='protenor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='protenor' OR species='protenor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='protenor' OR species='protenor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='protenor' OR junior_species='protenor')SELECT d.diet,d.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='protenor' OR species='protenor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='bootes' OR junior_species='bootes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='bootes' OR species='bootes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='bootes' OR species='bootes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='bootes' OR junior_species='bootes')SELECT d.diet,d.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='bootes' OR species='bootes') 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='xenocles' OR junior_species='xenocles')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphium' AND (species='xenocles' OR species='xenocles') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphium' AND (species='xenocles' OR species='xenocles')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='xenocles' OR junior_species='xenocles')SELECT d.diet,d.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='xenocles' OR species='xenocles') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='megarus' OR junior_species='megarus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphium' AND (species='megarus' OR species='megarus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphium' AND (species='megarus' OR species='megarus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='megarus' OR junior_species='megarus')SELECT d.diet,d.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='megarus' OR species='megarus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='macareus' OR junior_species='macareus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphium' AND (species='macareus' OR species='macareus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphium' AND (species='macareus' OR species='macareus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='macareus' OR junior_species='macareus')SELECT d.diet,d.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='macareus' OR species='macareus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='chironides' OR junior_species='chironides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphium' AND (species='chironides' OR species='chironides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphium' AND (species='chironides' OR species='chironides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='chironides' OR junior_species='chironides')SELECT d.diet,d.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='chironides' OR species='chironides') 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='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='Graphium' AND (junior_species='agetes' OR junior_species='agetes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphium' AND (species='agetes' OR species='agetes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphium' AND (species='agetes' OR species='agetes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='agetes' OR junior_species='agetes')SELECT d.diet,d.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='agetes' OR species='agetes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='cloanthus' OR junior_species='cloanthus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphium' AND (species='cloanthus' OR species='cloanthus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphium' AND (species='cloanthus' OR species='cloanthus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='cloanthus' OR junior_species='cloanthus')SELECT d.diet,d.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='cloanthus' OR species='cloanthus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='eurous' OR junior_species='eurous')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphium' AND (species='eurous' OR species='eurous') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphium' AND (species='eurous' OR species='eurous')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='eurous' OR junior_species='eurous')SELECT d.diet,d.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='eurous' OR species='eurous') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delias' AND (junior_species='pasithoe' OR junior_species='pasithoe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Delias' AND (species='pasithoe' OR species='pasithoe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Delias' AND (species='pasithoe' OR species='pasithoe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delias' AND (junior_species='pasithoe' OR junior_species='pasithoe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Delias' AND (species='pasithoe' OR species='pasithoe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delias' AND (junior_species='hyparete' OR junior_species='hyparete')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Delias' AND (species='hyparete' OR species='hyparete') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Delias' AND (species='hyparete' OR species='hyparete')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delias' AND (junior_species='hyparete' OR junior_species='hyparete')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Delias' AND (species='hyparete' OR species='hyparete') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delias' AND (junior_species='belladonna' OR junior_species='belladonna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Delias' AND (species='belladonna' OR species='belladonna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Delias' AND (species='belladonna' OR species='belladonna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delias' AND (junior_species='belladonna' OR junior_species='belladonna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Delias' AND (species='belladonna' OR species='belladonna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prioneris' AND (junior_species='thestylis' OR junior_species='thestylis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prioneris' AND (species='thestylis' OR species='thestylis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prioneris' AND (species='thestylis' OR species='thestylis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prioneris' AND (junior_species='thestylis' OR junior_species='thestylis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prioneris' AND (species='thestylis' OR species='thestylis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='canidia' OR junior_species='canidia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='canidia' OR species='canidia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='canidia' OR species='canidia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='canidia' OR junior_species='canidia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pieris' AND (species='canidia' OR species='canidia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talbotia' AND (junior_species='naganum' OR junior_species='naganum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Talbotia' AND (species='naganum' OR species='naganum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Talbotia' AND (species='naganum' OR species='naganum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talbotia' AND (junior_species='naganum' OR junior_species='naganum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Talbotia' AND (species='naganum' OR species='naganum') 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='Appias' AND (junior_species='indra' OR junior_species='indra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Appias' AND (species='indra' OR species='indra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Appias' AND (species='indra' OR species='indra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Appias' AND (junior_species='indra' OR junior_species='indra')SELECT d.diet,d.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='indra' OR species='indra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Appias' AND (junior_species='lalage' OR junior_species='lalage')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Appias' AND (species='lalage' OR species='lalage') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Appias' AND (species='lalage' OR species='lalage')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Appias' AND (junior_species='lalage' OR junior_species='lalage')SELECT d.diet,d.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='lalage' OR species='lalage') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dercas' AND (junior_species='verhueli' OR junior_species='verhuelii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dercas' AND (species='verhueli' OR species='verhuelii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dercas' AND (species='verhueli' OR species='verhuelii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dercas' AND (junior_species='verhueli' OR junior_species='verhuelii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dercas' AND (species='verhueli' OR species='verhuelii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsilia' 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='Catopsilia' AND (species='pomona' OR species='pomona') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catopsilia' AND (species='pomona' OR species='pomona')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsilia' 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='Catopsilia' AND (species='pomona' OR species='pomona') 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='Parantica' AND (junior_species='melaneus' OR junior_species='melaneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parantica' AND (species='melaneus' OR species='melaneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parantica' AND (species='melaneus' OR species='melaneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parantica' AND (junior_species='melaneus' OR junior_species='melaneus')SELECT d.diet,d.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='melaneus' OR species='melaneus') 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='Melanitis' 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='Melanitis' AND (species='leda' OR species='leda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanitis' AND (species='leda' OR species='leda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' 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='Melanitis' AND (species='leda' OR species='leda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='confusa' OR junior_species='confusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lethe' AND (species='confusa' OR species='confusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lethe' AND (species='confusa' OR species='confusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='confusa' OR junior_species='confusa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lethe' AND (species='confusa' OR species='confusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='verma' OR junior_species='verma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lethe' AND (species='verma' OR species='verma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lethe' AND (species='verma' OR species='verma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='verma' OR junior_species='verma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lethe' AND (species='verma' OR species='verma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='syrcis' OR junior_species='syrcis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lethe' AND (species='syrcis' OR species='syrcis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lethe' AND (species='syrcis' OR species='syrcis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='syrcis' OR junior_species='syrcis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lethe' AND (species='syrcis' OR species='syrcis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='insana' OR junior_species='insana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lethe' AND (species='insana' OR species='insana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lethe' AND (species='insana' OR species='insana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='insana' OR junior_species='insana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lethe' AND (species='insana' OR species='insana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='naga' OR junior_species='naga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lethe' AND (species='naga' OR species='naga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lethe' AND (species='naga' OR species='naga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='naga' OR junior_species='naga')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lethe' AND (species='naga' OR species='naga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neope' AND (junior_species='muirheadi' OR junior_species='muirheadii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neope' AND (species='muirheadi' OR species='muirheadii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neope' AND (species='muirheadi' OR species='muirheadii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neope' AND (junior_species='muirheadi' OR junior_species='muirheadii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neope' AND (species='muirheadi' OR species='muirheadii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='francisca' OR junior_species='francisca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='francisca' OR species='francisca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='francisca' OR species='francisca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='francisca' OR junior_species='francisca')SELECT d.diet,d.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='francisca' OR species='francisca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callerebia' AND (junior_species='narasingha' OR junior_species='narasingha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callerebia' AND (species='narasingha' OR species='narasingha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callerebia' AND (species='narasingha' OR species='narasingha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callerebia' AND (junior_species='narasingha' OR junior_species='narasingha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Callerebia' AND (species='narasingha' OR species='narasingha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discophora' AND (junior_species='sondaica' OR junior_species='sondaica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Discophora' AND (species='sondaica' OR species='sondaica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Discophora' AND (species='sondaica' OR species='sondaica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discophora' AND (junior_species='sondaica' OR junior_species='sondaica')SELECT d.diet,d.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='sondaica' OR species='sondaica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ariadne' AND (junior_species='merione' OR junior_species='merione')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ariadne' AND (species='merione' OR species='merione') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ariadne' AND (species='merione' OR species='merione')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ariadne' AND (junior_species='merione' OR junior_species='merione')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ariadne' AND (species='merione' OR species='merione') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasippa' AND (junior_species='tiga' OR junior_species='tiga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasippa' AND (species='tiga' OR species='tiga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasippa' AND (species='tiga' OR species='tiga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasippa' AND (junior_species='tiga' OR junior_species='tiga')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasippa' AND (species='tiga' OR species='tiga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pantoporia' AND (junior_species='hordonia' OR junior_species='hordonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pantoporia' AND (species='hordonia' OR species='hordonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pantoporia' AND (species='hordonia' OR species='hordonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pantoporia' AND (junior_species='hordonia' OR junior_species='hordonia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pantoporia' AND (species='hordonia' OR species='hordonia') 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='Kallima' AND (junior_species='inachus' OR junior_species='inachus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kallima' AND (species='inachus' OR species='inachus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kallima' AND (species='inachus' OR species='inachus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kallima' AND (junior_species='inachus' OR junior_species='inachus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Kallima' AND (species='inachus' OR species='inachus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyrestis' AND (junior_species='thyodamas' OR junior_species='thyodamas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyrestis' AND (species='thyodamas' OR species='thyodamas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyrestis' AND (species='thyodamas' OR species='thyodamas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyrestis' AND (junior_species='thyodamas' OR junior_species='thyodamas')SELECT d.diet,d.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='thyodamas' OR species='thyodamas') 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='miah' OR junior_species='miah')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='miah' OR species='miah') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='miah' OR species='miah')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='miah' OR junior_species='miah')SELECT d.diet,d.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='miah' OR species='miah') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='ananta' OR junior_species='ananta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='ananta' OR species='ananta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='ananta' OR species='ananta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='ananta' OR junior_species='ananta')SELECT d.diet,d.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='ananta' OR species='ananta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='namba' OR junior_species='namba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='namba' OR species='namba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='namba' OR species='namba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='namba' OR junior_species='namba')SELECT d.diet,d.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='namba' OR species='namba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='yerburii' OR junior_species='yerburi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='yerburii' OR species='yerburi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='yerburii' OR species='yerburi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='yerburii' OR junior_species='yerburi')SELECT d.diet,d.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='yerburii' OR species='yerburi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='harita' OR junior_species='harita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='harita' OR species='harita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='harita' OR species='harita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='harita' OR junior_species='harita')SELECT d.diet,d.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='harita' OR species='harita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='selenophora' OR junior_species='selenophora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Athyma' AND (species='selenophora' OR species='selenophora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Athyma' AND (species='selenophora' OR species='selenophora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='selenophora' OR junior_species='selenophora')SELECT d.diet,d.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='selenophora' OR species='selenophora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='cama' OR junior_species='cama')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Athyma' AND (species='cama' OR species='cama') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Athyma' AND (species='cama' OR species='cama')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='cama' OR junior_species='cama')SELECT d.diet,d.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='cama' OR species='cama') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='nefte' OR junior_species='nefte')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Athyma' AND (species='nefte' OR species='nefte') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Athyma' AND (species='nefte' OR species='nefte')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='nefte' OR junior_species='nefte')SELECT d.diet,d.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='nefte' OR species='nefte') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='asura' OR junior_species='asura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Athyma' AND (species='asura' OR species='asura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Athyma' AND (species='asura' OR species='asura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='asura' OR junior_species='asura')SELECT d.diet,d.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='asura' OR species='asura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='zeroca' OR junior_species='zeroca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Athyma' AND (species='zeroca' OR species='zeroca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Athyma' AND (species='zeroca' OR species='zeroca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='zeroca' OR junior_species='zeroca')SELECT d.diet,d.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='zeroca' OR species='zeroca') 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='Tanaecia' AND (junior_species='julii' OR junior_species='juli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tanaecia' AND (species='julii' OR species='juli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tanaecia' AND (species='julii' OR species='juli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tanaecia' AND (junior_species='julii' OR junior_species='juli')SELECT d.diet,d.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='julii' OR species='juli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='bernardus' OR junior_species='bernardus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='bernardus' OR species='bernardus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='bernardus' OR species='bernardus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='bernardus' OR junior_species='bernardus')SELECT d.diet,d.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='bernardus' OR species='bernardus') 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='nepenthes' OR junior_species='nepenthes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyura' AND (species='nepenthes' OR species='nepenthes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyura' AND (species='nepenthes' OR species='nepenthes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyura' AND (junior_species='nepenthes' OR junior_species='nepenthes')SELECT d.diet,d.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='nepenthes' OR species='nepenthes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyura' AND (junior_species='narcaea' OR junior_species='narcaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyura' AND (species='narcaea' OR species='narcaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyura' AND (species='narcaea' OR species='narcaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyura' AND (junior_species='narcaea' OR junior_species='narcaea')SELECT d.diet,d.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='narcaea' OR species='narcaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyura' AND (junior_species='dolon' OR junior_species='dolon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyura' AND (species='dolon' OR species='dolon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyura' AND (species='dolon' OR species='dolon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyura' AND (junior_species='dolon' OR junior_species='dolon')SELECT d.diet,d.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='dolon' OR species='dolon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyura' AND (junior_species='eudamippus' OR junior_species='eudamippus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyura' AND (species='eudamippus' OR species='eudamippus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyura' AND (species='eudamippus' OR species='eudamippus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyura' AND (junior_species='eudamippus' OR junior_species='eudamippus')SELECT d.diet,d.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='eudamippus' OR species='eudamippus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calinaga' AND (junior_species='buddha' OR junior_species='buddha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calinaga' AND (species='buddha' OR species='buddha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calinaga' AND (species='buddha' OR species='buddha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calinaga' AND (junior_species='buddha' OR junior_species='buddha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Calinaga' AND (species='buddha' OR species='buddha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abisara' AND (junior_species='fylla' OR junior_species='fylla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abisara' AND (species='fylla' OR species='fylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abisara' AND (species='fylla' OR species='fylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abisara' AND (junior_species='fylla' OR junior_species='fylla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Abisara' AND (species='fylla' OR species='fylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abisara' AND (junior_species='burnii' OR junior_species='burni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abisara' AND (species='burnii' OR species='burni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abisara' AND (species='burnii' OR species='burni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abisara' AND (junior_species='burnii' OR junior_species='burni')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Abisara' AND (species='burnii' OR species='burni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zemeros' AND (junior_species='flegyas' OR junior_species='flegyas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zemeros' AND (species='flegyas' OR species='flegyas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zemeros' AND (species='flegyas' OR species='flegyas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zemeros' AND (junior_species='flegyas' OR junior_species='flegyas')SELECT d.diet,d.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='flegyas' OR species='flegyas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dodona' AND (junior_species='dipoea' OR junior_species='dipoea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dodona' AND (species='dipoea' OR species='dipoea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dodona' AND (species='dipoea' OR species='dipoea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dodona' AND (junior_species='dipoea' OR junior_species='dipoea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dodona' AND (species='dipoea' OR species='dipoea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neopithecops' AND (junior_species='corvus' OR junior_species='corvus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neopithecops' AND (species='corvus' OR species='corvus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neopithecops' AND (species='corvus' OR species='corvus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neopithecops' AND (junior_species='corvus' OR junior_species='corvus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neopithecops' AND (species='corvus' OR species='corvus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neopithecops' AND (junior_species='zalmora' OR junior_species='zalmora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neopithecops' AND (species='zalmora' OR species='zalmora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neopithecops' AND (species='zalmora' OR species='zalmora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neopithecops' AND (junior_species='zalmora' OR junior_species='zalmora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neopithecops' AND (species='zalmora' OR species='zalmora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actyolepis' AND (junior_species='puspa' OR junior_species='puspa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Actyolepis' AND (species='puspa' OR species='puspa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Actyolepis' AND (species='puspa' OR species='puspa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actyolepis' AND (junior_species='puspa' OR junior_species='puspa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Actyolepis' AND (species='puspa' OR species='puspa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celastrina' AND (junior_species='argiolus' OR junior_species='argiolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celastrina' AND (species='argiolus' OR species='argiolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celastrina' AND (species='argiolus' OR species='argiolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celastrina' AND (junior_species='argiolus' OR junior_species='argiolus')SELECT d.diet,d.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='argiolus' OR species='argiolus') 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='Udara' AND (junior_species='dilecta' OR junior_species='dilecta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Udara' AND (species='dilecta' OR species='dilecta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Udara' AND (species='dilecta' OR species='dilecta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Udara' AND (junior_species='dilecta' OR junior_species='dilecta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Udara' AND (species='dilecta' OR species='dilecta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamipes' AND (junior_species='bochus' OR junior_species='bochus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jamipes' AND (species='bochus' OR species='bochus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jamipes' AND (species='bochus' OR species='bochus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamipes' AND (junior_species='bochus' OR junior_species='bochus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Jamipes' AND (species='bochus' OR species='bochus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ancema' AND (junior_species='ctesia' OR junior_species='ctesia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ancema' AND (species='ctesia' OR species='ctesia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ancema' AND (species='ctesia' OR species='ctesia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ancema' AND (junior_species='ctesia' OR junior_species='ctesia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ancema' AND (species='ctesia' OR species='ctesia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Surendra' AND (junior_species='quercetorum' OR junior_species='quercetorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Surendra' AND (species='quercetorum' OR species='quercetorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Surendra' AND (species='quercetorum' OR species='quercetorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Surendra' AND (junior_species='quercetorum' OR junior_species='quercetorum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Surendra' AND (species='quercetorum' OR species='quercetorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Curetis' AND (junior_species='bulis' OR junior_species='bulis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Curetis' AND (species='bulis' OR species='bulis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Curetis' AND (species='bulis' OR species='bulis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Curetis' AND (junior_species='bulis' OR junior_species='bulis')SELECT d.diet,d.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='bulis' OR species='bulis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celaenorrhinus' AND (junior_species='inaequalis' OR junior_species='inaequalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celaenorrhinus' AND (species='inaequalis' OR species='inaequalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celaenorrhinus' AND (species='inaequalis' OR species='inaequalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celaenorrhinus' AND (junior_species='inaequalis' OR junior_species='inaequalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Celaenorrhinus' AND (species='inaequalis' OR species='inaequalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tagiades' AND (junior_species='menaka' OR junior_species='menaka')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tagiades' AND (species='menaka' OR species='menaka') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tagiades' AND (species='menaka' OR species='menaka')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tagiades' AND (junior_species='menaka' OR junior_species='menaka')SELECT d.diet,d.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='menaka' OR species='menaka') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Seseria' AND (junior_species='dohertyi' OR junior_species='dohertyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Seseria' AND (species='dohertyi' OR species='dohertyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Seseria' AND (species='dohertyi' OR species='dohertyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Seseria' AND (junior_species='dohertyi' OR junior_species='dohertyii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Seseria' AND (species='dohertyi' OR species='dohertyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontoptilum' AND (junior_species='angulata' OR junior_species='angulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odontoptilum' AND (species='angulata' OR species='angulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontoptilum' AND (species='angulata' OR species='angulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontoptilum' AND (junior_species='angulata' OR junior_species='angulata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Odontoptilum' AND (species='angulata' OR species='angulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thoressa' AND (junior_species='gupta' OR junior_species='gupta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thoressa' AND (species='gupta' OR species='gupta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thoressa' AND (species='gupta' OR species='gupta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thoressa' AND (junior_species='gupta' OR junior_species='gupta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thoressa' AND (species='gupta' OR species='gupta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halpe' AND (junior_species='frontieri' OR junior_species='frontierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Halpe' AND (species='frontieri' OR species='frontierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halpe' AND (species='frontieri' OR species='frontierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halpe' AND (junior_species='frontieri' OR junior_species='frontierii')SELECT d.diet,d.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='frontieri' OR species='frontierii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iambrix' AND (junior_species='salsala' OR junior_species='salsala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Iambrix' AND (species='salsala' OR species='salsala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Iambrix' AND (species='salsala' OR species='salsala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iambrix' AND (junior_species='salsala' OR junior_species='salsala')SELECT d.diet,d.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='salsala' OR species='salsala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Koruthaialos' AND (junior_species='sindu' OR junior_species='sindu')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Koruthaialos' AND (species='sindu' OR species='sindu') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Koruthaialos' AND (species='sindu' OR species='sindu')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Koruthaialos' AND (junior_species='sindu' OR junior_species='sindu')SELECT d.diet,d.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='sindu' OR species='sindu') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notocrypta' AND (junior_species='curvifascia' OR junior_species='curvifascia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notocrypta' AND (species='curvifascia' OR species='curvifascia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notocrypta' AND (species='curvifascia' OR species='curvifascia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notocrypta' AND (junior_species='curvifascia' OR junior_species='curvifascia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Notocrypta' AND (species='curvifascia' OR species='curvifascia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlodes' AND (junior_species='siva' OR junior_species='siva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochlodes' AND (species='siva' OR species='siva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochlodes' AND (species='siva' OR species='siva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlodes' AND (junior_species='siva' OR junior_species='siva')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ochlodes' AND (species='siva' OR species='siva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pithauria' AND (junior_species='stramineipennis' OR junior_species='stramineipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pithauria' AND (species='stramineipennis' OR species='stramineipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pithauria' AND (species='stramineipennis' OR species='stramineipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pithauria' AND (junior_species='stramineipennis' OR junior_species='stramineipennis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pithauria' AND (species='stramineipennis' OR species='stramineipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ampitia' AND (junior_species='dioscorides' OR junior_species='dioscorides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ampitia' AND (species='dioscorides' OR species='dioscorides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ampitia' AND (species='dioscorides' OR species='dioscorides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ampitia' AND (junior_species='dioscorides' OR junior_species='dioscorides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ampitia' AND (species='dioscorides' OR species='dioscorides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Barba' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Barba' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Barba' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Barba' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Barba' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2304