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=284 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=284SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=119SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=284 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='epinome' OR junior_species='epinome')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='epinome' OR species='epinome') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='epinome' OR species='epinome')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='epinome' OR junior_species='epinome')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hamadryas' AND (species='epinome' OR species='epinome') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myscelia' AND (junior_species='orsis' OR junior_species='orsis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myscelia' AND (species='orsis' OR species='orsis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myscelia' AND (species='orsis' OR species='orsis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myscelia' AND (junior_species='orsis' OR junior_species='orsis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myscelia' AND (species='orsis' OR species='orsis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='februa' OR junior_species='februa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='februa' OR species='februa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='februa' OR species='februa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='februa' OR junior_species='februa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hamadryas' AND (species='februa' OR species='februa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='feronia' OR junior_species='feronia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='feronia' OR species='feronia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='feronia' OR species='feronia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='feronia' OR junior_species='feronia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hamadryas' AND (species='feronia' OR species='feronia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectima' AND (junior_species='thecla' OR junior_species='thecla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ectima' AND (species='thecla' OR species='thecla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ectima' AND (species='thecla' OR species='thecla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectima' AND (junior_species='thecla' OR junior_species='thecla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ectima' AND (species='thecla' OR species='thecla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiphile' AND (junior_species='orea' OR junior_species='orea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epiphile' AND (species='orea' OR species='orea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epiphile' AND (species='orea' OR species='orea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiphile' AND (junior_species='orea' OR junior_species='orea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Epiphile' AND (species='orea' OR species='orea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiphile' AND (junior_species='hubneri' OR junior_species='hubnerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epiphile' AND (species='hubneri' OR species='hubnerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epiphile' AND (species='hubneri' OR species='hubnerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiphile' AND (junior_species='hubneri' OR junior_species='hubnerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Epiphile' AND (species='hubneri' OR species='hubnerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Temenis' AND (junior_species='laothoe' OR junior_species='laothoe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Temenis' AND (species='laothoe' OR species='laothoe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Temenis' AND (species='laothoe' OR species='laothoe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Temenis' AND (junior_species='laothoe' OR junior_species='laothoe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Temenis' AND (species='laothoe' OR species='laothoe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='appias' OR junior_species='appias')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Memphis' AND (species='appias' OR species='appias') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memphis' AND (species='appias' OR species='appias')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='appias' OR junior_species='appias')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Memphis' AND (species='appias' OR species='appias') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fountainea' AND (junior_species='ryphea' OR junior_species='ryphea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fountainea' AND (species='ryphea' OR species='ryphea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fountainea' AND (species='ryphea' OR species='ryphea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fountainea' AND (junior_species='ryphea' OR junior_species='ryphea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Fountainea' AND (species='ryphea' OR species='ryphea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='otrere' OR junior_species='otrere')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Memphis' AND (species='otrere' OR species='otrere') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memphis' AND (species='otrere' OR species='otrere')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='otrere' OR junior_species='otrere')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Memphis' AND (species='otrere' OR species='otrere') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypna' AND (junior_species='clytemnestra' OR junior_species='clytemnestra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypna' AND (species='clytemnestra' OR species='clytemnestra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypna' AND (species='clytemnestra' OR species='clytemnestra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypna' AND (junior_species='clytemnestra' OR junior_species='clytemnestra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypna' AND (species='clytemnestra' OR species='clytemnestra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zaretis' AND (junior_species='isidora' OR junior_species='isidora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zaretis' AND (species='isidora' OR species='isidora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zaretis' AND (species='isidora' OR species='isidora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zaretis' AND (junior_species='isidora' OR junior_species='isidora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zaretis' AND (species='isidora' OR species='isidora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='moruus' OR junior_species='moruus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Memphis' AND (species='moruus' OR species='moruus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memphis' AND (species='moruus' OR species='moruus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='moruus' OR junior_species='moruus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Memphis' AND (species='moruus' OR species='moruus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeoprepona' AND (junior_species='chalciope' OR junior_species='chalciope')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archaeoprepona' AND (species='chalciope' OR species='chalciope') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archaeoprepona' AND (species='chalciope' OR species='chalciope')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeoprepona' AND (junior_species='chalciope' OR junior_species='chalciope')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Archaeoprepona' AND (species='chalciope' OR species='chalciope') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colobura' AND (junior_species='dirce' OR junior_species='dirce')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colobura' AND (species='dirce' OR species='dirce') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colobura' AND (species='dirce' OR species='dirce')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colobura' AND (junior_species='dirce' OR junior_species='dirce')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colobura' AND (species='dirce' OR species='dirce') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opoptera' AND (junior_species='syme' OR junior_species='syme')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Opoptera' AND (species='syme' OR species='syme') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Opoptera' AND (species='syme' OR species='syme')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opoptera' AND (junior_species='syme' OR junior_species='syme')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Opoptera' AND (species='syme' OR species='syme') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eryphanis' AND (junior_species='reevesi' OR junior_species='reevesii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eryphanis' AND (species='reevesi' OR species='reevesii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eryphanis' AND (species='reevesi' OR species='reevesii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eryphanis' AND (junior_species='reevesi' OR junior_species='reevesii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eryphanis' AND (species='reevesi' OR species='reevesii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyophthalma' AND (junior_species='creusa' OR junior_species='creusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasyophthalma' AND (species='creusa' OR species='creusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dasyophthalma' AND (species='creusa' OR species='creusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyophthalma' AND (junior_species='creusa' OR junior_species='creusa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dasyophthalma' AND (species='creusa' OR species='creusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caligo' AND (junior_species='arisbe' OR junior_species='arisbe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caligo' AND (species='arisbe' OR species='arisbe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caligo' AND (species='arisbe' OR species='arisbe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caligo' AND (junior_species='arisbe' OR junior_species='arisbe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Caligo' AND (species='arisbe' OR species='arisbe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opsiphanes' AND (junior_species='invirae' OR junior_species='invirae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Opsiphanes' AND (species='invirae' OR species='invirae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Opsiphanes' AND (species='invirae' OR species='invirae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opsiphanes' AND (junior_species='invirae' OR junior_species='invirae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Opsiphanes' AND (species='invirae' OR species='invirae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caligo' AND (junior_species='brasiliensis' OR junior_species='brasiliensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caligo' AND (species='brasiliensis' OR species='brasiliensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caligo' AND (species='brasiliensis' OR species='brasiliensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caligo' AND (junior_species='brasiliensis' OR junior_species='brasiliensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Caligo' AND (species='brasiliensis' OR species='brasiliensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='helenor' OR junior_species='helenor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Morpho' AND (species='helenor' OR species='helenor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Morpho' AND (species='helenor' OR species='helenor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='helenor' OR junior_species='helenor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Morpho' AND (species='helenor' OR species='helenor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Godartiana' AND (junior_species='muscosa' OR junior_species='muscosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Godartiana' AND (species='muscosa' OR species='muscosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Godartiana' AND (species='muscosa' OR species='muscosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Godartiana' AND (junior_species='muscosa' OR junior_species='muscosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Godartiana' AND (species='muscosa' OR species='muscosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moneuptychia' AND (junior_species='soter' OR junior_species='soter')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Moneuptychia' AND (species='soter' OR species='soter') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moneuptychia' AND (species='soter' OR species='soter')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moneuptychia' AND (junior_species='soter' OR junior_species='soter')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Moneuptychia' AND (species='soter' OR species='soter') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsterinaria' AND (junior_species='quantius' OR junior_species='quantius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Forsterinaria' AND (species='quantius' OR species='quantius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Forsterinaria' AND (species='quantius' OR species='quantius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsterinaria' AND (junior_species='quantius' OR junior_species='quantius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Forsterinaria' AND (species='quantius' OR species='quantius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hermeuptychia' AND (junior_species='hermes' OR junior_species='hermes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hermeuptychia' AND (species='hermes' OR species='hermes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hermeuptychia' AND (species='hermes' OR species='hermes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hermeuptychia' AND (junior_species='hermes' OR junior_species='hermes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hermeuptychia' AND (species='hermes' OR species='hermes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Splendeuptychia' AND (junior_species='doxes' OR junior_species='doxes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Splendeuptychia' AND (species='doxes' OR species='doxes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Splendeuptychia' AND (species='doxes' OR species='doxes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Splendeuptychia' AND (junior_species='doxes' OR junior_species='doxes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Splendeuptychia' AND (species='doxes' OR species='doxes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euptychoides' AND (junior_species='castrensis' OR junior_species='castrensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euptychoides' AND (species='castrensis' OR species='castrensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euptychoides' AND (species='castrensis' OR species='castrensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euptychoides' AND (junior_species='castrensis' OR junior_species='castrensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euptychoides' AND (species='castrensis' OR species='castrensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='phronius' OR junior_species='phronius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paryphthimoides' AND (species='phronius' OR species='phronius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paryphthimoides' AND (species='phronius' OR species='phronius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='phronius' OR junior_species='phronius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paryphthimoides' AND (species='phronius' OR species='phronius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsterinaria' AND (junior_species='necys' OR junior_species='necys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Forsterinaria' AND (species='necys' OR species='necys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Forsterinaria' AND (species='necys' OR species='necys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsterinaria' AND (junior_species='necys' OR junior_species='necys')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Forsterinaria' AND (species='necys' OR species='necys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='ochracea' OR junior_species='ochracea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Yphthimoides' AND (species='ochracea' OR species='ochracea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Yphthimoides' AND (species='ochracea' OR species='ochracea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='ochracea' OR junior_species='ochracea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Yphthimoides' AND (species='ochracea' OR species='ochracea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moneuptychia' AND (junior_species='griseldis' OR junior_species='griseldis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Moneuptychia' AND (species='griseldis' OR species='griseldis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moneuptychia' AND (species='griseldis' OR species='griseldis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moneuptychia' AND (junior_species='griseldis' OR junior_species='griseldis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Moneuptychia' AND (species='griseldis' OR species='griseldis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moneuptychia' AND (junior_species='paeon' OR junior_species='paeon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Moneuptychia' AND (species='paeon' OR species='paeon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moneuptychia' AND (species='paeon' OR species='paeon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moneuptychia' AND (junior_species='paeon' OR junior_species='paeon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Moneuptychia' AND (species='paeon' OR species='paeon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='ypthima' OR junior_species='ypthima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taygetis' AND (species='ypthima' OR species='ypthima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taygetis' AND (species='ypthima' OR species='ypthima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='ypthima' OR junior_species='ypthima')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Taygetis' AND (species='ypthima' OR species='ypthima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudodebis' AND (junior_species='euptychidia' OR junior_species='euptychidia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudodebis' AND (species='euptychidia' OR species='euptychidia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudodebis' AND (species='euptychidia' OR species='euptychidia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudodebis' AND (junior_species='euptychidia' OR junior_species='euptychidia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudodebis' AND (species='euptychidia' OR species='euptychidia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='borasta' OR junior_species='borasta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Yphthimoides' AND (species='borasta' OR species='borasta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Yphthimoides' AND (species='borasta' OR species='borasta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='borasta' OR junior_species='borasta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Yphthimoides' AND (species='borasta' OR species='borasta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pharneuptychia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pharneuptychia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pharneuptychia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pharneuptychia' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pharneuptychia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='poltys' OR junior_species='poltys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paryphthimoides' AND (species='poltys' OR species='poltys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paryphthimoides' AND (species='poltys' OR species='poltys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='poltys' OR junior_species='poltys')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paryphthimoides' AND (species='poltys' OR species='poltys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='grimon' OR junior_species='grimon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paryphthimoides' AND (species='grimon' OR species='grimon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paryphthimoides' AND (species='grimon' OR species='grimon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='grimon' OR junior_species='grimon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paryphthimoides' AND (species='grimon' OR species='grimon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='tripunctata' OR junior_species='tripunctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taygetis' AND (species='tripunctata' OR species='tripunctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taygetis' AND (species='tripunctata' OR species='tripunctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='tripunctata' OR junior_species='tripunctata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Taygetis' AND (species='tripunctata' OR species='tripunctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='laches' OR junior_species='laches')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taygetis' AND (species='laches' OR species='laches') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taygetis' AND (species='laches' OR species='laches')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='laches' OR junior_species='laches')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Taygetis' AND (species='laches' OR species='laches') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='angularis' OR junior_species='angularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Yphthimoides' AND (species='angularis' OR species='angularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Yphthimoides' AND (species='angularis' OR species='angularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='angularis' OR junior_species='angularis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Yphthimoides' AND (species='angularis' OR species='angularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='virgilia' OR junior_species='virgilia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taygetis' AND (species='virgilia' OR species='virgilia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taygetis' AND (species='virgilia' OR species='virgilia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='virgilia' OR junior_species='virgilia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Taygetis' AND (species='virgilia' OR species='virgilia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Splendeuptychia' AND (junior_species='ambra' OR junior_species='ambra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Splendeuptychia' AND (species='ambra' OR species='ambra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Splendeuptychia' AND (species='ambra' OR species='ambra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Splendeuptychia' AND (junior_species='ambra' OR junior_species='ambra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Splendeuptychia' AND (species='ambra' OR species='ambra') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=284
Sao Luiz do Paraitinga (Plot 10)
Basic information
Sample name: Sao Luiz do Paraitinga (Plot 10)

Reference: D. B. Ribeiro, R. Batista, P. I. Prado, K. S. Brown, and A. V. L. Freitas. 2012. The importance of small scales to the fruit-feeding butterfly assemblages in a fragmented landscape. Biodiversity and Conservation 21:811-827 [ER 119]
Geography
Country: Brazil

State: Sao Paulo


Coordinate: -23.1° S, -45.2° W
Geography comments: Field work was carried out near the scarps of the Serra do Mar mountain range (p. 813)

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: fragment

Substrate: ground surface

MAT: 20.2

WMT: 28.6

CMT: 9.5

MAP: 1340.0

Habitat comments: "The original vegetation of this area was dense humid forest. Over the past two centuries, forest fragmentation has drastically changed the landscape of the region. At the beginning of the eighteenth century, human activity in this landscape replaced native rain forest with ranching areas and small crop fields. Around 1760, massive coffee plantations were planted in this region, and deforestation rates increased. Defor- estation then accelerated with the decline of coffee plantations and the increase of dairy farming in the 1930s. Currently, most of the original vegetation is gone, and the remaining forest persists as small fragments surrounded by a matrix of crop fields, Eucalyptus plantations, ranching areas and abandoned pastures" (P. 813)

Methods
Life forms: butterflies

Site length: 30

Sampling methods: line transect,butterfly nets

Sample size: 741 captures or sightings

Years: 2004-2005

Metadata
Sample number: 284

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-04-09 14:29:09

Modified: 2015-02-23 02:32:01

Abundance distribution
45 species
9 singletons
total count 741
extrapolated richness: 69.1
Fisher's α: 10.548
geometric series k: 0.8981
Hurlbert's PIE: 0.9227
Shannon's H: 2.9668
Good's u: 0.9879
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Hamadryas epinome75
Myscelia orsis108
Hamadryas februa113
Hamadryas feronia19
Ectima thecla2
Epiphile orea1
Epiphile hubneri4
Temenis laothoe1
Memphis appias18
Fountainea ryphea7
Memphis otrere12
Hypna clytemnestra4
Zaretis isidora4
Memphis moruus2
Archaeoprepona chalciope2
Colobura dirce2
Opoptera syme51
Eryphanis reevesi17
Dasyophthalma creusa1
Caligo arisbe4
Opsiphanes invirae1
Caligo brasiliensis1
Morpho helenor5
Godartiana muscosa41
Moneuptychia soter51
Forsterinaria quantius5
Hermeuptychia hermes31
Splendeuptychia doxes32
Euptychoides castrensis18
Paryphthimoides phronius12
Forsterinaria necys1
Yphthimoides ochracea20
Moneuptychia griseldis7
Moneuptychia paeon2
Taygetis ypthima6
Pseudodebis euptychidia33
Yphthimoides borasta2
Pharneuptychia sp.6
Paryphthimoides poltys6
Paryphthimoides grimon3
Taygetis tripunctata3
Taygetis laches5
Yphthimoides angularis1
Taygetis virgilia1
Splendeuptychia ambra1