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=977 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=977SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=670SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=977 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Borbo' AND (junior_species='borbonica' OR junior_species='borbonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Borbo' AND (species='borbonica' OR species='borbonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Borbo' AND (species='borbonica' OR species='borbonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Borbo' AND (junior_species='borbonica' OR junior_species='borbonica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Borbo' AND (species='borbonica' OR species='borbonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Borbo' AND (junior_species='gemella' OR junior_species='gemella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Borbo' AND (species='gemella' OR species='gemella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Borbo' AND (species='gemella' OR species='gemella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Borbo' AND (junior_species='gemella' OR junior_species='gemella')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Borbo' AND (species='gemella' OR species='gemella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Borbo' AND (junior_species='ratek' OR junior_species='ratek')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Borbo' AND (species='ratek' OR species='ratek') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Borbo' AND (species='ratek' OR species='ratek')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Borbo' AND (junior_species='ratek' OR junior_species='ratek')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Borbo' AND (species='ratek' OR species='ratek') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliades' AND (junior_species='forestan' OR junior_species='forestan')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coeliades' AND (species='forestan' OR species='forestan') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coeliades' AND (species='forestan' OR species='forestan')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliades' AND (junior_species='forestan' OR junior_species='forestan')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coeliades' AND (species='forestan' OR species='forestan') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliades' AND (junior_species='rama' OR junior_species='rama')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coeliades' AND (species='rama' OR species='rama') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coeliades' AND (species='rama' OR species='rama')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliades' AND (junior_species='rama' OR junior_species='rama')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coeliades' AND (species='rama' OR species='rama') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliades' AND (junior_species='ramanatek' OR junior_species='ramanatek')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coeliades' AND (species='ramanatek' OR species='ramanatek') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coeliades' AND (species='ramanatek' OR species='ramanatek')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliades' AND (junior_species='ramanatek' OR junior_species='ramanatek')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coeliades' AND (species='ramanatek' OR species='ramanatek') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fulda' AND (junior_species='imorina' OR junior_species='imorina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fulda' AND (species='imorina' OR species='imorina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fulda' AND (species='imorina' OR species='imorina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fulda' AND (junior_species='imorina' OR junior_species='imorina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Fulda' AND (species='imorina' OR species='imorina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tagiades' AND (junior_species='insularis' OR junior_species='insularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tagiades' AND (species='insularis' OR species='insularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tagiades' AND (species='insularis' OR species='insularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tagiades' AND (junior_species='insularis' OR junior_species='insularis')SELECT d.diet,d.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='insularis' OR species='insularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthene' AND (junior_species='princeps' OR junior_species='princeps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthene' AND (species='princeps' OR species='princeps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthene' AND (species='princeps' OR species='princeps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthene' AND (junior_species='princeps' OR junior_species='princeps')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anthene' AND (species='princeps' OR species='princeps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Azanus' AND (junior_species='sitalces' OR junior_species='sitalces')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Azanus' AND (species='sitalces' OR species='sitalces') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Azanus' AND (species='sitalces' OR species='sitalces')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Azanus' AND (junior_species='sitalces' OR junior_species='sitalces')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Azanus' AND (species='sitalces' OR species='sitalces') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Azanus' AND (junior_species='soalalicus' OR junior_species='soalalicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Azanus' AND (species='soalalicus' OR species='soalalicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Azanus' AND (species='soalalicus' OR species='soalalicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Azanus' AND (junior_species='soalalicus' OR junior_species='soalalicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Azanus' AND (species='soalalicus' OR species='soalalicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chilades' AND (junior_species='trochylus' OR junior_species='trochylus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chilades' AND (species='trochylus' OR species='trochylus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chilades' AND (species='trochylus' OR species='trochylus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chilades' AND (junior_species='trochylus' OR junior_species='trochylus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chilades' AND (species='trochylus' OR species='trochylus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eicochrysops' AND (junior_species='sanguigutta' OR junior_species='sanguigutta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eicochrysops' AND (species='sanguigutta' OR species='sanguigutta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eicochrysops' AND (species='sanguigutta' OR species='sanguigutta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eicochrysops' AND (junior_species='sanguigutta' OR junior_species='sanguigutta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eicochrysops' AND (species='sanguigutta' OR species='sanguigutta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euchrysops' AND (junior_species='malathana' OR junior_species='malathana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euchrysops' AND (species='malathana' OR species='malathana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euchrysops' AND (species='malathana' OR species='malathana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euchrysops' AND (junior_species='malathana' OR junior_species='malathana')SELECT d.diet,d.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='malathana' OR species='malathana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemiolaus' AND (junior_species='cobaltina' OR junior_species='cobaltina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemiolaus' AND (species='cobaltina' OR species='cobaltina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemiolaus' AND (species='cobaltina' OR species='cobaltina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemiolaus' AND (junior_species='cobaltina' OR junior_species='cobaltina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hemiolaus' AND (species='cobaltina' OR species='cobaltina') 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='Leptotes' AND (junior_species='pirithous' OR junior_species='pirithous')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptotes' AND (species='pirithous' OR species='pirithous') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptotes' AND (species='pirithous' OR species='pirithous')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotes' AND (junior_species='pirithous' OR junior_species='pirithous')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptotes' AND (species='pirithous' OR species='pirithous') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotes' AND (junior_species='rabefaner' OR junior_species='rabefaner')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptotes' AND (species='rabefaner' OR species='rabefaner') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptotes' AND (species='rabefaner' OR species='rabefaner')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotes' AND (junior_species='rabefaner' OR junior_species='rabefaner')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptotes' AND (species='rabefaner' OR species='rabefaner') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizeeria' AND (junior_species='knysna' OR junior_species='knysna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zizeeria' AND (species='knysna' OR species='knysna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zizeeria' AND (species='knysna' OR species='knysna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizeeria' AND (junior_species='knysna' OR junior_species='knysna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zizeeria' AND (species='knysna' OR species='knysna') 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='Acraea' AND (junior_species='calida' OR junior_species='calida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acraea' AND (species='calida' OR species='calida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acraea' AND (species='calida' OR species='calida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='calida' OR junior_species='calida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acraea' AND (species='calida' OR species='calida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='dammii' OR junior_species='dammi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acraea' AND (species='dammii' OR species='dammi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acraea' AND (species='dammii' OR species='dammi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='dammii' OR junior_species='dammi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acraea' AND (species='dammii' OR species='dammi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='encedon' OR junior_species='encedon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acraea' AND (species='encedon' OR species='encedon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acraea' AND (species='encedon' OR species='encedon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='encedon' OR junior_species='encedon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acraea' AND (species='encedon' OR species='encedon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='eponina' OR junior_species='eponina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acraea' AND (species='eponina' OR species='eponina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acraea' AND (species='eponina' OR species='eponina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='eponina' OR junior_species='eponina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acraea' AND (species='eponina' OR species='eponina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='masamba' OR junior_species='masamba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acraea' AND (species='masamba' OR species='masamba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acraea' AND (species='masamba' OR species='masamba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='masamba' OR junior_species='masamba')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acraea' AND (species='masamba' OR species='masamba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='ranavalona' OR junior_species='ranavalona')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acraea' AND (species='ranavalona' OR species='ranavalona') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acraea' AND (species='ranavalona' OR species='ranavalona')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='ranavalona' OR junior_species='ranavalona')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acraea' AND (species='ranavalona' OR species='ranavalona') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='zitja' OR junior_species='zitja')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acraea' AND (species='zitja' OR species='zitja') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acraea' AND (species='zitja' OR species='zitja')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='zitja' OR junior_species='zitja')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acraea' AND (species='zitja' OR species='zitja') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aterica' AND (junior_species='rabena' OR junior_species='rabena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aterica' AND (species='rabena' OR species='rabena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aterica' AND (species='rabena' OR species='rabena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aterica' AND (junior_species='rabena' OR junior_species='rabena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aterica' AND (species='rabena' OR species='rabena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Byblia' AND (junior_species='anvatara' OR junior_species='anvatara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Byblia' AND (species='anvatara' OR species='anvatara') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Byblia' AND (species='anvatara' OR species='anvatara')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Byblia' AND (junior_species='anvatara' OR junior_species='anvatara')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Byblia' AND (species='anvatara' OR species='anvatara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyrestis' AND (junior_species='camillus' OR junior_species='camillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyrestis' AND (species='camillus' OR species='camillus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyrestis' AND (species='camillus' OR species='camillus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyrestis' AND (junior_species='camillus' OR junior_species='camillus')SELECT d.diet,d.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='camillus' OR species='camillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='chrysippus' OR junior_species='chrysippus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Danaus' AND (species='chrysippus' OR species='chrysippus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Danaus' AND (species='chrysippus' OR species='chrysippus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='chrysippus' OR junior_species='chrysippus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Danaus' AND (species='chrysippus' OR species='chrysippus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurytela' AND (junior_species='narinda' OR junior_species='narinda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurytela' AND (species='narinda' OR species='narinda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurytela' AND (species='narinda' OR species='narinda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurytela' AND (junior_species='narinda' OR junior_species='narinda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eurytela' AND (species='narinda' OR species='narinda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropsis' AND (junior_species='ankaratra' OR junior_species='ankaratra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteropsis' AND (species='ankaratra' OR species='ankaratra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteropsis' AND (species='ankaratra' OR species='ankaratra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropsis' AND (junior_species='ankaratra' OR junior_species='ankaratra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heteropsis' AND (species='ankaratra' OR species='ankaratra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropsis' AND (junior_species='ankoma' OR junior_species='ankoma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteropsis' AND (species='ankoma' OR species='ankoma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteropsis' AND (species='ankoma' OR species='ankoma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropsis' AND (junior_species='ankoma' OR junior_species='ankoma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heteropsis' AND (species='ankoma' OR species='ankoma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropsis' AND (junior_species='narcissus' OR junior_species='narcissus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteropsis' AND (species='narcissus' OR species='narcissus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteropsis' AND (species='narcissus' OR species='narcissus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropsis' AND (junior_species='narcissus' OR junior_species='narcissus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heteropsis' AND (species='narcissus' OR species='narcissus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropsis' AND (junior_species='strigula' OR junior_species='strigula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteropsis' AND (species='strigula' OR species='strigula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteropsis' AND (species='strigula' OR species='strigula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropsis' AND (junior_species='strigula' OR junior_species='strigula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heteropsis' AND (species='strigula' OR species='strigula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropsis' AND (junior_species='vola' OR junior_species='vola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteropsis' AND (species='vola' OR species='vola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteropsis' AND (species='vola' OR species='vola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropsis' AND (junior_species='vola' OR junior_species='vola')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heteropsis' AND (species='vola' OR species='vola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolimnas' AND (junior_species='misippus' OR junior_species='misippus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypolimnas' AND (species='misippus' OR species='misippus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypolimnas' AND (species='misippus' OR species='misippus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolimnas' AND (junior_species='misippus' OR junior_species='misippus')SELECT d.diet,d.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='misippus' OR species='misippus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='goudotii' OR junior_species='goudoti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='goudotii' OR species='goudoti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='goudotii' OR species='goudoti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='goudotii' OR junior_species='goudoti')SELECT d.diet,d.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='goudotii' OR species='goudoti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='oenone' OR junior_species='oenone')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='oenone' OR species='oenone') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='oenone' OR species='oenone')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='oenone' OR junior_species='oenone')SELECT d.diet,d.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='oenone' OR species='oenone') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='orithya' OR junior_species='orithya')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='orithya' OR species='orithya') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='orithya' OR species='orithya')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='orithya' OR junior_species='orithya')SELECT d.diet,d.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='orithya' OR species='orithya') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='rhadama' OR junior_species='rhadama')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='rhadama' OR species='rhadama') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='rhadama' OR species='rhadama')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='rhadama' OR junior_species='rhadama')SELECT d.diet,d.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='rhadama' OR species='rhadama') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limenitis' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limenitis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limenitis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limenitis' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Limenitis' AND (species='sp.' OR species='sp.') 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='Neptidopsis' AND (junior_species='fulgurata' OR junior_species='fulgurata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptidopsis' AND (species='fulgurata' OR species='fulgurata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptidopsis' AND (species='fulgurata' OR species='fulgurata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptidopsis' AND (junior_species='fulgurata' OR junior_species='fulgurata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neptidopsis' AND (species='fulgurata' OR species='fulgurata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='kikideli' OR junior_species='kikidelii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='kikideli' OR species='kikidelii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='kikideli' OR species='kikidelii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='kikideli' OR junior_species='kikidelii')SELECT d.diet,d.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='kikideli' OR species='kikidelii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='saclava' OR junior_species='saclava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='saclava' OR species='saclava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='saclava' OR species='saclava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='saclava' OR junior_species='saclava')SELECT d.diet,d.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='saclava' OR species='saclava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardopsis' AND (junior_species='punctatissima' OR junior_species='punctatissima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pardopsis' AND (species='punctatissima' OR species='punctatissima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pardopsis' AND (species='punctatissima' OR species='punctatissima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardopsis' AND (junior_species='punctatissima' OR junior_species='punctatissima')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pardopsis' AND (species='punctatissima' OR species='punctatissima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalanta' AND (junior_species='madagascariensis' OR junior_species='madagascariensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phalanta' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phalanta' AND (species='madagascariensis' OR species='madagascariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalanta' AND (junior_species='madagascariensis' OR junior_species='madagascariensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phalanta' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalanta' AND (junior_species='phalantha' OR junior_species='phalantha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phalanta' AND (species='phalantha' OR species='phalantha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phalanta' AND (species='phalantha' OR species='phalantha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalanta' AND (junior_species='phalantha' OR junior_species='phalantha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phalanta' AND (species='phalantha' OR species='phalantha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='cyrnus' OR junior_species='cyrnus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphium' AND (species='cyrnus' OR species='cyrnus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphium' AND (species='cyrnus' OR species='cyrnus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='cyrnus' OR junior_species='cyrnus')SELECT d.diet,d.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='cyrnus' OR species='cyrnus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='demodocus' OR junior_species='demodocus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='demodocus' OR species='demodocus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='demodocus' OR species='demodocus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='demodocus' OR junior_species='demodocus')SELECT d.diet,d.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='demodocus' OR species='demodocus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='epiphorbas' OR junior_species='epiphorbas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='epiphorbas' OR species='epiphorbas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='epiphorbas' OR species='epiphorbas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='epiphorbas' OR junior_species='epiphorbas')SELECT d.diet,d.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='epiphorbas' OR species='epiphorbas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='grosesmithi' OR junior_species='grosesmithii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='grosesmithi' OR species='grosesmithii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='grosesmithi' OR species='grosesmithii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='grosesmithi' OR junior_species='grosesmithii')SELECT d.diet,d.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='grosesmithi' OR species='grosesmithii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Belenois' AND (junior_species='antsianaka' OR junior_species='antsianaka')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Belenois' AND (species='antsianaka' OR species='antsianaka') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Belenois' AND (species='antsianaka' OR species='antsianaka')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Belenois' AND (junior_species='antsianaka' OR junior_species='antsianaka')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Belenois' AND (species='antsianaka' OR species='antsianaka') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsilia' AND (junior_species='florella' OR junior_species='florella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catopsilia' AND (species='florella' OR species='florella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catopsilia' AND (species='florella' OR species='florella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsilia' AND (junior_species='florella' OR junior_species='florella')SELECT d.diet,d.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='florella' OR species='florella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsilia' AND (junior_species='thauruma' OR junior_species='thauruma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catopsilia' AND (species='thauruma' OR species='thauruma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catopsilia' AND (species='thauruma' OR species='thauruma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsilia' AND (junior_species='thauruma' OR junior_species='thauruma')SELECT d.diet,d.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='thauruma' OR species='thauruma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='evanthe' OR junior_species='evanthe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colotis' AND (species='evanthe' OR species='evanthe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colotis' AND (species='evanthe' OR species='evanthe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='evanthe' OR junior_species='evanthe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colotis' AND (species='evanthe' OR species='evanthe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='lucas' OR junior_species='lucas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colotis' AND (species='lucas' OR species='lucas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colotis' AND (species='lucas' OR species='lucas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='lucas' OR junior_species='lucas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colotis' AND (species='lucas' OR species='lucas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='brigitta' OR junior_species='brigitta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='brigitta' OR species='brigitta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='brigitta' OR species='brigitta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='brigitta' OR junior_species='brigitta')SELECT d.diet,d.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='brigitta' OR species='brigitta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='floricola' OR junior_species='floricola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='floricola' OR species='floricola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='floricola' OR species='floricola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='floricola' OR junior_species='floricola')SELECT d.diet,d.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='floricola' OR species='floricola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptosia' AND (junior_species='alcesta' OR junior_species='alcesta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptosia' AND (species='alcesta' OR species='alcesta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptosia' AND (species='alcesta' OR species='alcesta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptosia' AND (junior_species='alcesta' OR junior_species='alcesta')SELECT d.diet,d.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='alcesta' OR species='alcesta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mylothris' AND (junior_species='phileris' OR junior_species='phileris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mylothris' AND (species='phileris' OR species='phileris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mylothris' AND (species='phileris' OR species='phileris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mylothris' AND (junior_species='phileris' OR junior_species='phileris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mylothris' AND (species='phileris' OR species='phileris') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=977 The Ecological Register: Tsarakibany
Tsarakibany
Basic information
Sample name: Tsarakibany

Reference: M. D. Steer, A. Vater, and S. McCann-Wood. 2009. The effect of forest degradation on the species richness and diversity of a diurnal Lepidoptera community in northern Madagascar. Frontier Madagascar Environmental Research Report 22:1-20 [ER 670]
Geography
Country: Madagascar


Coordinate: -12.4649° S, 49.1021° E
Coordinate basis: stated in text

Geography comments: "approximately 85km south of Antsiranana"

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: disturbed forest

Substrate: ground surface

Disturbance: grazing,selective logging

MAT: 29.0

MAP: 2328.0

Habitat comments: "The majority of secondary forest fragments have been altered with the introduction of productive species" and there is "zebu grazing, selective logging and charcoaling"
mean precip is 14 mm per day from November to March (= 2114 mm) and 1 mm per day from April to December (= 214 mm); MAT is 28 during the dry season and peaks out at 31 during the wet season, so 29 seems like a good guess

Methods
Life forms: butterflies

Sites: 4

Sampling methods: sweep nets,visual

Sample size: 783 individuals

Days: 28

Sampling comments: sweep netting plus visual counts: there were seven surveys each of four sites (apparently one day each) for a total of 176 man hours

Metadata
Sample number: 977

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-06-27 21:43:31

Modified: 2014-07-13 07:40:39

Abundance distribution
63 species
13 singletons
total count 783
extrapolated richness: 98.2
Fisher's α: 16.146
geometric series k: 0.9292
Hurlbert's PIE: 0.9509
Shannon's H: 3.4180
Good's u: 0.9834
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Borbo borbonica borbonica1
Borbo gemella13
Borbo ratek3
Coeliades forestan arbogastes2
Coeliades rama4
Coeliades ramanatek ramanatek5
Fulda imorina1
Tagiades insularis insularis4
Anthene princeps smithii3
Azanus sitalces3
Azanus soalalicus14
Chilades trochylus9
Eicochrysops sanguigutta12
Euchrysops malathana58
Hemiolaus cobaltina15
Lampides boeticus1
Leptotes pirithous14
Leptotes rabefaner5
Zizeeria knysna35
Zizula hylax95
Acraea calida2
Acraea dammii7
Acraea encedon encedon39
Acraea eponina13
Acraea masamba2
Acraea ranavalona7
Acraea zitja29
Aterica rabena9
Byblia anvatara anvatara19
Cyrestis camillus elegans8
Danaus chrysippus aegyptus56
Eurytela narinda3
Heteropsis ankaratra2
Heteropsis ankoma7
Heteropsis narcissus fraterna2
Heteropsis strigula2
Heteropsis vola2
Hypolimnas misippus2
Junonia goudotii33
Junonia oenone epiclelia13
Junonia orithya madagascariensis1
Junonia rhadama16
Limenitis sp.1
Melanitis leda helena1
Neptidopsis fulgurata fulgurata2
Neptis kikideli7
Neptis saclava saclava1
Pardopsis punctatissima12
Phalanta madagascariensis1
Phalanta phalantha8
Graphium cyrnus1
Papilio demodocus demodocus1
Papilio epiphorbas5
Papilio grosesmithi1
Belenois antsianaka1
Catopsilia florella44
Catopsilia thauruma6
Colotis evanthe6
Colotis lucas1
Eurema brigitta brigitta8
Eurema floricola floricola45
Leptosia alcesta sylvicola55
Mylothris phileris5