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=2371 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2371SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2272SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2371 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andronymus' AND (junior_species='hero' OR junior_species='hero')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andronymus' AND (species='hero' OR species='hero') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andronymus' AND (species='hero' OR species='hero')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andronymus' AND (junior_species='hero' OR junior_species='hero')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Andronymus' AND (species='hero' OR species='hero') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ariadne' AND (junior_species='enotrea' OR junior_species='enotrea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ariadne' AND (species='enotrea' OR species='enotrea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ariadne' AND (species='enotrea' OR species='enotrea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ariadne' AND (junior_species='enotrea' OR junior_species='enotrea')SELECT d.diet,d.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='enotrea' OR species='enotrea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aterica' AND (junior_species='galene' OR junior_species='galene')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aterica' AND (species='galene' OR species='galene') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aterica' AND (species='galene' OR species='galene')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aterica' AND (junior_species='galene' OR junior_species='galene')SELECT d.diet,d.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='galene' OR species='galene') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='absolon' OR junior_species='absolon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bebearia' AND (species='absolon' OR species='absolon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bebearia' AND (species='absolon' OR species='absolon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='absolon' OR junior_species='absolon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bebearia' AND (species='absolon' OR species='absolon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='demetra' OR junior_species='demetra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bebearia' AND (species='demetra' OR species='demetra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bebearia' AND (species='demetra' OR species='demetra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='demetra' OR junior_species='demetra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bebearia' AND (species='demetra' OR species='demetra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='lucayensis' OR junior_species='lucayensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bebearia' AND (species='lucayensis' OR species='lucayensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bebearia' AND (species='lucayensis' OR species='lucayensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='lucayensis' OR junior_species='lucayensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bebearia' AND (species='lucayensis' OR species='lucayensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='mandinga' OR junior_species='mandinga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bebearia' AND (species='mandinga' OR species='mandinga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bebearia' AND (species='mandinga' OR species='mandinga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='mandinga' OR junior_species='mandinga')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bebearia' AND (species='mandinga' OR species='mandinga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='mardania' OR junior_species='mardania')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bebearia' AND (species='mardania' OR species='mardania') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bebearia' AND (species='mardania' OR species='mardania')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='mardania' OR junior_species='mardania')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bebearia' AND (species='mardania' OR species='mardania') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='oxione' OR junior_species='oxione')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bebearia' AND (species='oxione' OR species='oxione') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bebearia' AND (species='oxione' OR species='oxione')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='oxione' OR junior_species='oxione')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bebearia' AND (species='oxione' OR species='oxione') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='phantasina' OR junior_species='phantasina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bebearia' AND (species='phantasina' OR species='phantasina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bebearia' AND (species='phantasina' OR species='phantasina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='phantasina' OR junior_species='phantasina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bebearia' AND (species='phantasina' OR species='phantasina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='sophus' OR junior_species='sophus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bebearia' AND (species='sophus' OR species='sophus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bebearia' AND (species='sophus' OR species='sophus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='sophus' OR junior_species='sophus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bebearia' AND (species='sophus' OR species='sophus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='tentyris' OR junior_species='tentyris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bebearia' AND (species='tentyris' OR species='tentyris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bebearia' AND (species='tentyris' OR species='tentyris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='tentyris' OR junior_species='tentyris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bebearia' AND (species='tentyris' OR species='tentyris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='zonara' OR junior_species='zonara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bebearia' AND (species='zonara' OR species='zonara') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bebearia' AND (species='zonara' OR species='zonara')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='zonara' OR junior_species='zonara')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bebearia' AND (species='zonara' OR species='zonara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='abnormis' OR junior_species='abnormis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='abnormis' OR species='abnormis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='abnormis' OR species='abnormis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='abnormis' OR junior_species='abnormis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='abnormis' OR species='abnormis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='funebris' OR junior_species='funebris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='funebris' OR species='funebris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='funebris' OR species='funebris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='funebris' OR junior_species='funebris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='funebris' OR species='funebris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='madetes' OR junior_species='madetes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='madetes' OR species='madetes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='madetes' OR species='madetes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='madetes' OR junior_species='madetes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='madetes' OR species='madetes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='martius' OR junior_species='martius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='martius' OR species='martius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='martius' OR species='martius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='martius' OR junior_species='martius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='martius' OR species='martius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='procora' OR junior_species='procora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='procora' OR species='procora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='procora' OR species='procora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='procora' OR junior_species='procora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='procora' OR species='procora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='safitza' OR junior_species='safitza')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='safitza' OR species='safitza') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='safitza' OR species='safitza')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='safitza' OR junior_species='safitza')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='safitza' OR species='safitza') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='sandace' OR junior_species='sandace')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='sandace' OR species='sandace') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='sandace' OR species='sandace')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='sandace' OR junior_species='sandace')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='sandace' OR species='sandace') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='sangmelinae' OR junior_species='sangmelinae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='sangmelinae' OR species='sangmelinae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='sangmelinae' OR species='sangmelinae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='sangmelinae' OR junior_species='sangmelinae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='sangmelinae' OR species='sangmelinae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='taenias' OR junior_species='taenias')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='taenias' OR species='taenias') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='taenias' OR species='taenias')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='taenias' OR junior_species='taenias')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='taenias' OR species='taenias') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='vulgaris' OR junior_species='vulgaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='vulgaris' OR species='vulgaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='vulgaris' OR species='vulgaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='vulgaris' OR junior_species='vulgaris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='vulgaris' OR species='vulgaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='xeneas' OR junior_species='xeneas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='xeneas' OR species='xeneas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='xeneas' OR species='xeneas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='xeneas' OR junior_species='xeneas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='xeneas' OR species='xeneas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='zinebi' OR junior_species='zinebii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='zinebi' OR species='zinebii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='zinebi' OR species='zinebii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='zinebi' OR junior_species='zinebii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='zinebi' OR species='zinebii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='anticlea' OR junior_species='anticlea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='anticlea' OR species='anticlea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='anticlea' OR species='anticlea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='anticlea' OR junior_species='anticlea')SELECT d.diet,d.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='anticlea' OR species='anticlea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='brutus' OR junior_species='brutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='brutus' OR species='brutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='brutus' OR species='brutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='brutus' OR junior_species='brutus')SELECT d.diet,d.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='brutus' OR species='brutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='cynthia' OR junior_species='cynthia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='cynthia' OR species='cynthia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='cynthia' OR species='cynthia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='cynthia' OR junior_species='cynthia')SELECT d.diet,d.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='cynthia' OR species='cynthia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='etheocles' OR junior_species='etheocles')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='etheocles' OR species='etheocles') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='etheocles' OR species='etheocles')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='etheocles' OR junior_species='etheocles')SELECT d.diet,d.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='etheocles' OR species='etheocles') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='lucretius' OR junior_species='lucretius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='lucretius' OR species='lucretius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='lucretius' OR species='lucretius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='lucretius' OR junior_species='lucretius')SELECT d.diet,d.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='lucretius' OR species='lucretius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='numenes' OR junior_species='numenes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='numenes' OR species='numenes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='numenes' OR species='numenes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='numenes' OR junior_species='numenes')SELECT d.diet,d.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='numenes' OR species='numenes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='protoclea' OR junior_species='protoclea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='protoclea' OR species='protoclea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='protoclea' OR species='protoclea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='protoclea' OR junior_species='protoclea')SELECT d.diet,d.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='protoclea' OR species='protoclea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymothoe' AND (junior_species='egesta' OR junior_species='egesta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cymothoe' AND (species='egesta' OR species='egesta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cymothoe' AND (species='egesta' OR species='egesta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymothoe' AND (junior_species='egesta' OR junior_species='egesta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cymothoe' AND (species='egesta' OR species='egesta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymothoe' AND (junior_species='fumana' OR junior_species='fumana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cymothoe' AND (species='fumana' OR species='fumana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cymothoe' AND (species='fumana' OR species='fumana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymothoe' AND (junior_species='fumana' OR junior_species='fumana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cymothoe' AND (species='fumana' OR species='fumana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymothoe' AND (junior_species='mabillei' OR junior_species='mabilleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cymothoe' AND (species='mabillei' OR species='mabilleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cymothoe' AND (species='mabillei' OR species='mabilleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymothoe' AND (junior_species='mabillei' OR junior_species='mabilleii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cymothoe' AND (species='mabillei' OR species='mabilleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elymniopsis' AND (junior_species='bammakoo' OR junior_species='bammakoo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elymniopsis' AND (species='bammakoo' OR species='bammakoo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elymniopsis' AND (species='bammakoo' OR species='bammakoo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elymniopsis' AND (junior_species='bammakoo' OR junior_species='bammakoo')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elymniopsis' AND (species='bammakoo' OR species='bammakoo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='ceres' OR junior_species='ceres')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='ceres' OR species='ceres') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='ceres' OR species='ceres')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='ceres' OR junior_species='ceres')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphaedra' AND (species='ceres' OR species='ceres') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='hebes' OR junior_species='hebes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='hebes' OR species='hebes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='hebes' OR species='hebes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='hebes' OR junior_species='hebes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphaedra' AND (species='hebes' OR species='hebes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='inanum' OR junior_species='inanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='inanum' OR species='inanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='inanum' OR species='inanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='inanum' OR junior_species='inanum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphaedra' AND (species='inanum' OR species='inanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='janetta' OR junior_species='janetta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='janetta' OR species='janetta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='janetta' OR species='janetta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='janetta' OR junior_species='janetta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphaedra' AND (species='janetta' OR species='janetta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='medon' OR junior_species='medon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='medon' OR species='medon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='medon' OR species='medon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='medon' OR junior_species='medon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphaedra' AND (species='medon' OR species='medon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='modesta' OR junior_species='modesta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='modesta' OR species='modesta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='modesta' OR species='modesta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='modesta' OR junior_species='modesta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphaedra' AND (species='modesta' OR species='modesta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='phaethusa' OR junior_species='phaethusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='phaethusa' OR species='phaethusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='phaethusa' OR species='phaethusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='phaethusa' OR junior_species='phaethusa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphaedra' AND (species='phaethusa' OR species='phaethusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='themis' OR junior_species='themis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='themis' OR species='themis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='themis' OR species='themis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='themis' OR junior_species='themis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphaedra' AND (species='themis' OR species='themis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='xypete' OR junior_species='xypete')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='xypete' OR species='xypete') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='xypete' OR species='xypete')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='xypete' OR junior_species='xypete')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphaedra' AND (species='xypete' OR species='xypete') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euriphene' AND (junior_species='amicia' OR junior_species='amicia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euriphene' AND (species='amicia' OR species='amicia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euriphene' AND (species='amicia' OR species='amicia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euriphene' AND (junior_species='amicia' OR junior_species='amicia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euriphene' AND (species='amicia' OR species='amicia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euriphene' AND (junior_species='ampedusa' OR junior_species='ampedusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euriphene' AND (species='ampedusa' OR species='ampedusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euriphene' AND (species='ampedusa' OR species='ampedusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euriphene' AND (junior_species='ampedusa' OR junior_species='ampedusa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euriphene' AND (species='ampedusa' OR species='ampedusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euriphene' AND (junior_species='aridatha' OR junior_species='aridatha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euriphene' AND (species='aridatha' OR species='aridatha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euriphene' AND (species='aridatha' OR species='aridatha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euriphene' AND (junior_species='aridatha' OR junior_species='aridatha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euriphene' AND (species='aridatha' OR species='aridatha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euriphene' AND (junior_species='barombina' OR junior_species='barombina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euriphene' AND (species='barombina' OR species='barombina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euriphene' AND (species='barombina' OR species='barombina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euriphene' AND (junior_species='barombina' OR junior_species='barombina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euriphene' AND (species='barombina' OR species='barombina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euriphene' AND (junior_species='gambiae' OR junior_species='gambiae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euriphene' AND (species='gambiae' OR species='gambiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euriphene' AND (species='gambiae' OR species='gambiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euriphene' AND (junior_species='gambiae' OR junior_species='gambiae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euriphene' AND (species='gambiae' OR species='gambiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euriphene' AND (junior_species='simplex' OR junior_species='simplex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euriphene' AND (species='simplex' OR species='simplex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euriphene' AND (species='simplex' OR species='simplex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euriphene' AND (junior_species='simplex' OR junior_species='simplex')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euriphene' AND (species='simplex' OR species='simplex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnophodes' AND (junior_species='betsimena' OR junior_species='betsimena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gnophodes' AND (species='betsimena' OR species='betsimena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gnophodes' AND (species='betsimena' OR species='betsimena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnophodes' AND (junior_species='betsimena' OR junior_species='betsimena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gnophodes' AND (species='betsimena' OR species='betsimena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnophodes' AND (junior_species='chelys' OR junior_species='chelys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gnophodes' AND (species='chelys' OR species='chelys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gnophodes' AND (species='chelys' OR species='chelys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnophodes' AND (junior_species='chelys' OR junior_species='chelys')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gnophodes' AND (species='chelys' OR species='chelys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harma' AND (junior_species='theobene' OR junior_species='theobene')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harma' AND (species='theobene' OR species='theobene') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harma' AND (species='theobene' OR species='theobene')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harma' AND (junior_species='theobene' OR junior_species='theobene')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Harma' AND (species='theobene' OR species='theobene') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolycaena' AND (junior_species='antifaunus' OR junior_species='antifaunus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypolycaena' AND (species='antifaunus' OR species='antifaunus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypolycaena' AND (species='antifaunus' OR species='antifaunus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolycaena' AND (junior_species='antifaunus' OR junior_species='antifaunus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypolycaena' AND (species='antifaunus' OR species='antifaunus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolycaena' AND (junior_species='dubia' OR junior_species='dubia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypolycaena' AND (species='dubia' OR species='dubia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypolycaena' AND (species='dubia' OR species='dubia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolycaena' AND (junior_species='dubia' OR junior_species='dubia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypolycaena' AND (species='dubia' OR species='dubia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolycaena' AND (junior_species='kakumi' OR junior_species='kakumii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypolycaena' AND (species='kakumi' OR species='kakumii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypolycaena' AND (species='kakumi' OR species='kakumii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolycaena' AND (junior_species='kakumi' OR junior_species='kakumii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypolycaena' AND (species='kakumi' OR species='kakumii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lachnoptera' AND (junior_species='anticlia' OR junior_species='anticlia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lachnoptera' AND (species='anticlia' OR species='anticlia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lachnoptera' AND (species='anticlia' OR species='anticlia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lachnoptera' AND (junior_species='anticlia' OR junior_species='anticlia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lachnoptera' AND (species='anticlia' OR species='anticlia') 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='ophione' OR junior_species='ophione')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptidopsis' AND (species='ophione' OR species='ophione') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptidopsis' AND (species='ophione' OR species='ophione')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptidopsis' AND (junior_species='ophione' OR junior_species='ophione')SELECT d.diet,d.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='ophione' OR species='ophione') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='metella' OR junior_species='metella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='metella' OR species='metella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='metella' OR species='metella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='metella' OR junior_species='metella')SELECT d.diet,d.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='metella' OR species='metella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxylides' AND (junior_species='faunus' OR junior_species='faunus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxylides' AND (species='faunus' OR species='faunus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxylides' AND (species='faunus' OR species='faunus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxylides' AND (junior_species='faunus' OR junior_species='faunus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oxylides' AND (species='faunus' OR species='faunus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palla' AND (junior_species='decius' OR junior_species='decius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palla' AND (species='decius' OR species='decius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palla' AND (species='decius' OR species='decius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palla' AND (junior_species='decius' OR junior_species='decius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Palla' AND (species='decius' OR species='decius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palla' AND (junior_species='ussheri' OR junior_species='ussherii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palla' AND (species='ussheri' OR species='ussherii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palla' AND (species='ussheri' OR species='ussherii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palla' AND (junior_species='ussheri' OR junior_species='ussherii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Palla' AND (species='ussheri' OR species='ussherii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudacraea' AND (junior_species='lucretia' OR junior_species='lucretia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudacraea' AND (species='lucretia' OR species='lucretia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudacraea' AND (species='lucretia' OR species='lucretia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudacraea' AND (junior_species='lucretia' OR junior_species='lucretia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudacraea' AND (species='lucretia' OR species='lucretia') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2371 The Ecological Register: Bobiri Forest Reserve (2005, 2006)
Bobiri Forest Reserve (2005, 2006)
Basic information
Sample name: Bobiri Forest Reserve (2005, 2006)

Reference: J. L. Bossart and J. B. Antwi. 2016. Limited erosion of genetic and species diversity from small forest patches: Sacred forest groves in an Afrotropical biodiversity hotspot have high conservation value for butterflies. Biological Conservation 198:122-134 [ER 2272]
Geography
Country: Ghana


Coordinate: 6° 42' N, 1° 15' W
Coordinate basis: stated in text

Geography comments: "centered around Kumasi"
altitude is based on Chiti et al. (2016)

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: forest reserve

Substrate: ground surface

MAT: 26.0

MAP: 1475.0

Habitat comments: a 5000 ha reserve of "moist semi-deciduous forest... completely surrounded by farm bush savanna"
climate data are for the Bobiri forest reserve and is based on Chiti et al. (2016)

Methods
Life forms: butterflies

Sampling methods: line transect,baited,other traps

Sample size: 1273 individuals

Years: 2005, 2006

Nets or traps: 16

Net or trap nights: 224

Trap spacing: 0.08

Sampling comments: "The fruit-feeding butterfly community... was sampled using typical fruit-bait traps. Traps were hung in the understory 8–10 cm above the ground. Three to four traps were installed at 80 m intervals along each of two to four 'straight line' transects"... Individual transects were located in discrete areas of the forest at least 300 m distant... Trap sampling was initiated July 2005 and continued through May 2006. In general, samples were collected from each site on a 3-week rotational basis. Each sampling bout consisted of two sampling days. Traps were baited with mashed, fermenting banana, and butterflies collected the following day ~24 h later. Traps were then re-baited and left for an additional 24 h, after which trapped butterflies were again retrieved

Metadata
Sample number: 2371

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-12-01 20:41:32

Modified: 2016-12-12 23:56:09

Abundance distribution
65 species
16 singletons
total count 1273
extrapolated richness: 104.3
Fisher's α: 14.485
geometric series k: 0.9181
Hurlbert's PIE: 0.9257
Shannon's H: 3.1545
Good's u: 0.9874
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Andronymus hero1
Ariadne enotrea2
Aterica galene25
Bebearia absolon36
Bebearia demetra1
Bebearia lucayensis2
Bebearia mandinga2
Bebearia mardania1
Bebearia oxione1
Bebearia phantasina7
Bebearia sophus16
Bebearia tentyris127
Bebearia zonara31
Bicyclus abnormis237
Bicyclus funebris149
Bicyclus madetes25
Bicyclus martius33
Bicyclus procora8
Bicyclus safitza2
Bicyclus sandace2
Bicyclus sangmelinae5
Bicyclus taenias17
Bicyclus vulgaris62
Bicyclus xeneas19
Bicyclus zinebi4
Charaxes anticlea1
Charaxes brutus1
Charaxes cynthia8
Charaxes etheocles1
Charaxes lucretius1
Charaxes numenes2
Charaxes protoclea4
Cymothoe egesta16
Cymothoe fumana4
Cymothoe mabillei3
Elymniopsis bammakoo17
Euphaedra ceres15
Euphaedra hebes3
Euphaedra inanum4
Euphaedra janetta4
Euphaedra medon45
Euphaedra modesta2
Euphaedra phaethusa60
Euphaedra themis24
Euphaedra xypete1
Euriphene amicia4
Euriphene ampedusa9
Euriphene aridatha8
Euriphene barombina25
Euriphene gambiae20
Euriphene simplex37
Gnophodes betsimena76
Gnophodes chelys22
Harma theobene5
Hypolycaena antifaunus1
Hypolycaena dubia4
Hypolycaena kakumi1
Lachnoptera anticlia1
Melanitis leda17
Neptidopsis ophione1
Neptis metella1
Oxylides faunus1
Palla decius1
Palla ussheri6
Pseudacraea lucretia2