Coordinate: 5° 21' 36" N, 1° 22' 9" W
MAP about 1600 and temperature ranges "throughout the year" from "18.2 to 32.1º C" (not clear if this means daily or between extremes) according to Monney et al. 2011
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=1306 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1306SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=672SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1306 ORDER BY register_no ASCSELECT 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='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='Melanitis' AND (junior_species='libya' OR junior_species='libya')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanitis' AND (species='libya' OR species='libya') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanitis' AND (species='libya' OR species='libya')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='libya' OR junior_species='libya')SELECT d.diet,d.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='libya' OR species='libya') 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='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='evadne' OR junior_species='evadne')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='evadne' OR species='evadne') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='evadne' OR species='evadne')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='evadne' OR junior_species='evadne')SELECT d.diet,d.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='evadne' OR species='evadne') 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='larseni' OR junior_species='larsenii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='larseni' OR species='larsenii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='larseni' OR species='larsenii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='larseni' OR junior_species='larsenii')SELECT d.diet,d.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='larseni' OR species='larsenii') 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='dorothea' OR junior_species='dorothea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='dorothea' OR species='dorothea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='dorothea' OR species='dorothea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='dorothea' OR junior_species='dorothea')SELECT d.diet,d.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='dorothea' OR species='dorothea') 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='sambulos' OR junior_species='sambulos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='sambulos' OR species='sambulos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='sambulos' OR species='sambulos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='sambulos' OR junior_species='sambulos')SELECT d.diet,d.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='sambulos' OR species='sambulos') 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='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='Hallelesis' AND (junior_species='halyma' OR junior_species='halyma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hallelesis' AND (species='halyma' OR species='halyma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hallelesis' AND (species='halyma' OR species='halyma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hallelesis' AND (junior_species='halyma' OR junior_species='halyma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hallelesis' AND (species='halyma' OR species='halyma') 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='Charaxes' AND (junior_species='boueti' OR junior_species='bouetii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='boueti' OR species='bouetii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='boueti' OR species='bouetii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='boueti' OR junior_species='bouetii')SELECT d.diet,d.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='boueti' OR species='bouetii') 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='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='castor' OR junior_species='castor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='castor' OR species='castor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='castor' OR species='castor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='castor' OR junior_species='castor')SELECT d.diet,d.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='castor' OR species='castor') 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='pollux' OR junior_species='pollux')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='pollux' OR species='pollux') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='pollux' OR species='pollux')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='pollux' OR junior_species='pollux')SELECT d.diet,d.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='pollux' OR species='pollux') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='tiridates' OR junior_species='tiridates')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='tiridates' OR species='tiridates') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='tiridates' OR species='tiridates')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='tiridates' OR junior_species='tiridates')SELECT d.diet,d.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='tiridates' OR species='tiridates') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='bipunctatus' OR junior_species='bipunctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='bipunctatus' OR species='bipunctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='bipunctatus' OR species='bipunctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='bipunctatus' OR junior_species='bipunctatus')SELECT d.diet,d.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='bipunctatus' OR species='bipunctatus') 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='zingha' OR junior_species='zingha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='zingha' OR species='zingha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='zingha' OR species='zingha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='zingha' OR junior_species='zingha')SELECT d.diet,d.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='zingha' OR species='zingha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='eupale' OR junior_species='eupale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='eupale' OR species='eupale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='eupale' OR species='eupale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='eupale' OR junior_species='eupale')SELECT d.diet,d.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='eupale' OR species='eupale') 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='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='pleione' OR junior_species='pleione')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='pleione' OR species='pleione') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='pleione' OR species='pleione')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='pleione' OR junior_species='pleione')SELECT d.diet,d.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='pleione' OR species='pleione') 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='Palla' AND (junior_species='publius' OR junior_species='publius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palla' AND (species='publius' OR species='publius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palla' AND (species='publius' OR species='publius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palla' AND (junior_species='publius' OR junior_species='publius')SELECT d.diet,d.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='publius' OR species='publius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kallimoides' AND (junior_species='rumia' OR junior_species='rumia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kallimoides' AND (species='rumia' OR species='rumia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kallimoides' AND (species='rumia' OR species='rumia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kallimoides' AND (junior_species='rumia' OR junior_species='rumia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Kallimoides' AND (species='rumia' OR species='rumia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolimnas' AND (junior_species='salmacis' OR junior_species='salmacis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypolimnas' AND (species='salmacis' OR species='salmacis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypolimnas' AND (species='salmacis' OR species='salmacis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolimnas' AND (junior_species='salmacis' OR junior_species='salmacis')SELECT d.diet,d.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='salmacis' OR species='salmacis') 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='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='druryi' OR junior_species='druryii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cymothoe' AND (species='druryi' OR species='druryii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cymothoe' AND (species='druryi' OR species='druryii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymothoe' AND (junior_species='druryi' OR junior_species='druryii')SELECT d.diet,d.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='druryi' OR species='druryii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euryphura' AND (junior_species='chalcis' OR junior_species='chalcis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euryphura' AND (species='chalcis' OR species='chalcis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euryphura' AND (species='chalcis' OR species='chalcis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euryphura' AND (junior_species='chalcis' OR junior_species='chalcis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euryphura' AND (species='chalcis' OR species='chalcis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamanumida' AND (junior_species='daedalus' OR junior_species='daedalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamanumida' AND (species='daedalus' OR species='daedalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamanumida' AND (species='daedalus' OR species='daedalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamanumida' AND (junior_species='daedalus' OR junior_species='daedalus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hamanumida' AND (species='daedalus' OR species='daedalus') 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='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='cocalia' OR junior_species='cocalia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bebearia' AND (species='cocalia' OR species='cocalia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bebearia' AND (species='cocalia' OR species='cocalia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='cocalia' OR junior_species='cocalia')SELECT d.diet,d.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='cocalia' OR species='cocalia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='paludicola' OR junior_species='paludicola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bebearia' AND (species='paludicola' OR species='paludicola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bebearia' AND (species='paludicola' OR species='paludicola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='paludicola' OR junior_species='paludicola')SELECT d.diet,d.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='paludicola' OR species='paludicola') 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='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='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='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='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='harpalyce' OR junior_species='harpalyce')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='harpalyce' OR species='harpalyce') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='harpalyce' OR species='harpalyce')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='harpalyce' OR junior_species='harpalyce')SELECT d.diet,d.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='harpalyce' OR species='harpalyce') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1306