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=2352 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2352SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2262SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2352 ORDER BY register_no ASCSELECT 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='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='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='Elymnias' 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='Elymnias' AND (species='bammakoo' OR species='bammakoo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elymnias' AND (species='bammakoo' OR species='bammakoo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elymnias' 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='Elymnias' AND (species='bammakoo' OR species='bammakoo') 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='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='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='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='abesa' OR junior_species='abesa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bebearia' AND (species='abesa' OR species='abesa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bebearia' AND (species='abesa' OR species='abesa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bebearia' AND (junior_species='abesa' OR junior_species='abesa')SELECT d.diet,d.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='abesa' OR species='abesa') 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='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='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='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='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='caerulea' OR junior_species='caerulea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euriphene' AND (species='caerulea' OR species='caerulea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euriphene' AND (species='caerulea' OR species='caerulea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euriphene' AND (junior_species='caerulea' OR junior_species='caerulea')SELECT d.diet,d.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='caerulea' OR species='caerulea') 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='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='eupalus' OR junior_species='eupalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='eupalus' OR species='eupalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='eupalus' OR species='eupalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='eupalus' OR junior_species='eupalus')SELECT d.diet,d.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='eupalus' OR species='eupalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='gausape' OR junior_species='gausape')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='gausape' OR species='gausape') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='gausape' OR species='gausape')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='gausape' OR junior_species='gausape')SELECT d.diet,d.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='gausape' OR species='gausape') 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 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='phaetusa' OR junior_species='phaetusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='phaetusa' OR species='phaetusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='phaetusa' OR species='phaetusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='phaetusa' OR junior_species='phaetusa')SELECT d.diet,d.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='phaetusa' OR species='phaetusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='perseis' OR junior_species='perseis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='perseis' OR species='perseis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='perseis' OR species='perseis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='perseis' OR junior_species='perseis')SELECT d.diet,d.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='perseis' OR species='perseis') 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='Catuna' AND (junior_species='crithea' OR junior_species='crithea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catuna' AND (species='crithea' OR species='crithea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catuna' AND (species='crithea' OR species='crithea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catuna' AND (junior_species='crithea' OR junior_species='crithea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catuna' AND (species='crithea' OR species='crithea') 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='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 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='fulvescens' OR junior_species='fulvescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='fulvescens' OR species='fulvescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='fulvescens' OR species='fulvescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='fulvescens' OR junior_species='fulvescens')SELECT d.diet,d.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='fulvescens' OR species='fulvescens') 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='Charaxes' AND (junior_species='varanes' OR junior_species='varanes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='varanes' OR species='varanes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='varanes' OR species='varanes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='varanes' OR junior_species='varanes')SELECT d.diet,d.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='varanes' OR species='varanes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kallima' 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='Kallima' AND (species='rumia' OR species='rumia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kallima' AND (species='rumia' OR species='rumia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kallima' 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='Kallima' AND (species='rumia' OR species='rumia') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2352 The Ecological Register: Bobiri Forest Reserve (2001, 2002)
Bobiri Forest Reserve (2001, 2002)
Basic information
Sample name: Bobiri Forest Reserve (2001, 2002)

Reference: J. L. Bossart, E. Opuni-Frimpong, S. Kuudaar, and E. Nkrumah. 2006. Richness, abundance, and complementarity of fruit-feeding butterfly species in relict sacred forests and forest reserves of Ghana. Biodiversity and Conservation 15:333-359 [ER 2262]
Geography
Country: Ghana


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

Geography comments: coordinate originally given at 6º 40' N, 1º 19' W; revised figures are given by Bossart and Antwi (2016)
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 consisting of "moist semi-deciduous forest"
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: 1626 individuals

Years: 2001, 2002

Days: 22

Seasons: dry,wet or monsoon

Nets or traps: 15

Net or trap nights: 330

Sampling comments: 15 traps set out in three five-trap transects for a total of 330 trap days
"Trap sampling was initiated late June 2001 and continued through July 2002. Sampling was more frequent during the rainy season... In general, trapping occurred weekly from late June through mid August 2001, monthly between August 2001 and mid May 2002, then biweekly from mid May through late July 2002... Typical fruit-bait traps were hung in the forest understory, approximately 10 cm above the ground... Individual traps within areas were separated from each other by at least 50 m and by no more than 200 m. Traps were baited with mashed, fermented banana"

Metadata
Sample number: 2352

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-10-29 13:52:36

Modified: 2016-12-12 23:56:06

Abundance distribution
59 species
9 singletons
total count 1626
extrapolated richness: 80.7
Fisher's α: 12.001
geometric series k: 0.9010
Hurlbert's PIE: 0.9029
Shannon's H: 3.0279
Good's u: 0.9945
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Bicyclus abnormis20
Bicyclus dorothea6
Bicyclus funebris99
Bicyclus madetes5
Bicyclus martius11
Bicyclus procora4
Bicyclus safitza4
Bicyclus sandace3
Bicyclus sangmelinae18
Bicyclus taenias2
Bicyclus vulgaris46
Bicyclus xeneas10
Bicyclus zinebi8
Elymnias bammakoo5
Gnophodes betsimena86
Gnophodes chelys18
Hallelesis halyma1
Melanitis leda15
Melanitis libya4
Aterica galene78
Bebearia abesa7
Bebearia absolon36
Bebearia cocalia25
Bebearia demetra2
Bebearia mandinga14
Bebearia mardania26
Bebearia oxione7
Bebearia phantasina19
Bebearia sophus27
Bebearia tentyris422
Bebearia zonara86
Euriphene amicia1
Euriphene ampedusa3
Euriphene aridatha8
Euriphene barombina37
Euriphene caerulea1
Euriphene gambiae17
Euriphene simplex14
Euphaedra ceres73
Euphaedra eupalus4
Euphaedra gausape1
Euphaedra harpalyce30
Euphaedra hebes6
Euphaedra inanum7
Euphaedra janetta17
Euphaedra medon163
Euphaedra phaetusa55
Euphaedra perseis4
Euphaedra themis42
Euphaedra xypete11
Catuna crithea2
Cymothoe fumana1
Pseudacraea lucretia1
Charaxes bipunctatus1
Charaxes fulvescens3
Charaxes numenes1
Charaxes protoclea5
Charaxes varanes1
Kallima rumia3