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=1325 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1325SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=885SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1325 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catonephele' AND (junior_species='acontius' OR junior_species='acontius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catonephele' AND (species='acontius' OR species='acontius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catonephele' AND (species='acontius' OR species='acontius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catonephele' AND (junior_species='acontius' OR junior_species='acontius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catonephele' AND (species='acontius' OR species='acontius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catonephele' AND (junior_species='numilia' OR junior_species='numilia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catonephele' AND (species='numilia' OR species='numilia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catonephele' AND (species='numilia' OR species='numilia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catonephele' AND (junior_species='numilia' OR junior_species='numilia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catonephele' AND (species='numilia' OR species='numilia') 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='Hamadryas' AND (junior_species='amphinome' OR junior_species='amphinome')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='amphinome' OR species='amphinome') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='amphinome' OR species='amphinome')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='amphinome' OR junior_species='amphinome')SELECT d.diet,d.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='amphinome' OR species='amphinome') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='arete' OR junior_species='arete')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='arete' OR species='arete') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='arete' OR species='arete')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='arete' OR junior_species='arete')SELECT d.diet,d.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='arete' OR species='arete') ORDER BY year,last_namesSELECT 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='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='Hamadryas' AND (junior_species='iphthime' OR junior_species='iphthime')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='iphthime' OR species='iphthime') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='iphthime' OR species='iphthime')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='iphthime' OR junior_species='iphthime')SELECT d.diet,d.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='iphthime' OR species='iphthime') 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='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='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='Pareuptychia' AND (junior_species='ocirrhoe' OR junior_species='ocirrhoe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pareuptychia' AND (species='ocirrhoe' OR species='ocirrhoe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pareuptychia' AND (species='ocirrhoe' OR species='ocirrhoe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareuptychia' AND (junior_species='ocirrhoe' OR junior_species='ocirrhoe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pareuptychia' AND (species='ocirrhoe' OR species='ocirrhoe') 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='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='Catoblepia' AND (junior_species='berecynthia' OR junior_species='berecynthia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catoblepia' AND (species='berecynthia' OR species='berecynthia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catoblepia' AND (species='berecynthia' OR species='berecynthia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catoblepia' AND (junior_species='berecynthia' OR junior_species='berecynthia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catoblepia' AND (species='berecynthia' OR species='berecynthia') 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='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='Opsiphanes' AND (junior_species='quiteria' OR junior_species='quiteria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Opsiphanes' AND (species='quiteria' OR species='quiteria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Opsiphanes' AND (species='quiteria' OR species='quiteria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opsiphanes' AND (junior_species='quiteria' OR junior_species='quiteria')SELECT d.diet,d.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='quiteria' OR species='quiteria') 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='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='Smyrna' AND (junior_species='blomfildia' OR junior_species='blomfildia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Smyrna' AND (species='blomfildia' OR species='blomfildia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Smyrna' AND (species='blomfildia' OR species='blomfildia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Smyrna' AND (junior_species='blomfildia' OR junior_species='blomfildia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Smyrna' AND (species='blomfildia' OR species='blomfildia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeoprepona' AND (junior_species='amphimachus' OR junior_species='amphimachus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archaeoprepona' AND (species='amphimachus' OR species='amphimachus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archaeoprepona' AND (species='amphimachus' OR species='amphimachus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeoprepona' AND (junior_species='amphimachus' OR junior_species='amphimachus')SELECT d.diet,d.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='amphimachus' OR species='amphimachus') 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='Archaeoprepona' AND (junior_species='demophon' OR junior_species='demophon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archaeoprepona' AND (species='demophon' OR species='demophon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archaeoprepona' AND (species='demophon' OR species='demophon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeoprepona' AND (junior_species='demophon' OR junior_species='demophon')SELECT d.diet,d.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='demophon' OR species='demophon') 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='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='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 * FROM register WHERE sample_no=1325<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<title>
The Ecological Register: Campinas
</title>

<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">

<link rel="stylesheet" type="text/css" href="/html/eco.css">
<link rel="icon" href="/html/huntsman-ico.tiff" type="image/x-icon">
<link rel="shortcut icon" href="/html/huntsman-ico.tiff" type="image/x-icon">

<meta name="keywords" content="ecology, biodiversity, species diversity, abundance distributions, database">
<meta name="description" content="">

</head>

<body>

<div id="banner">

<div style="position: relative; top: 4px; left: 4px;">
<a class="bannerLink" href="?page=home" style="color: White;">
<img alt="huntsman spider" src="/images/huntsman.jpg" height="50" style="border: 0;">
</a>
</div>

<div style="position: relative; top: -38px; margin-left: 60px; margin-bottom: -82px; font-family: Palatino, Garamond, serif; font-size: 2.5em; color: FireBrick;">
<a class="bannerLink" href="?page=home">
<span class="bannerLink">
<img src="/images/SlabTallX_logo.png" style="height: 44px; margin-top: -4px; border: 0;">
</span>
</a>
</div>

<div style="position: relative; overflow: hidden; height: 58px; width: 28em; top: -8px; margin-left: 32em;">

</div>

</div>

<div id="navBar">

<div class="navBarLink">
  <a href="/?a=sampleSearch">Samples</a>
</div>
<div class="navBarLink">
  <a href="/?a=taxonSearch">Species</a>
</div>
<div class="navBarLink">
  <a href="/?page=search_refs">References</a>
</div>
<div class="navBarLink bannerLink">
<form method="POST" action="" onSubmit="return checkName(0,2);">
<input type="hidden" name="a" value="quickSearch">
<input type="text" id="quick_search" name="quick_search" value="Quick search" onFocus="document.getElementById('quick_search').value ='';" onBlur="document.getElementById('quick_search').value ='Quick search';" style="position: relative; width: 7em; padding-left: 0.2em; font-family: Palatino, Garamond, serif; font-size: 1em; background: White; color: FireBrick; border: 0px; margin: 0em; padding: 0em;">
</form>
</div>
<div class="navBarLink">
<a href="?a=downloadForm">Download</a>
</div>
<div class="navBarLink">
<a href="?a=sampleSearch&amp;goal=compare">Compare</a>
</div>
<div class="navBarLink">
<a href="?a=cluster&amp;life_form=bats&amp;clusters=3&amp;level=both">Biogeography</a>
</div>
<div class="navBarLink">
<a href="?page=FAQ">FAQ</a>
</div>
<div class="navBarLink">
<a class="bannerLink" href="/?a=loginForm">Log in</a>
</div>

</div>



<div id="mainPanel">

<style>
<!--
.myPanel	{
	width: 95%;
}
.not_comment	{
	float: left;
	clear: none;
	white-space: nowrap;
}
.comment	{
	float: left;
	clear: left;
	margin-left: 1em;
	text-indent: -1em;
	line-height: 1em;
}
.field	{
	margin-right: 0.2em;
}
.value	{
	margin-right: 1.5em;
	padding-left: 0.25em;
}
.first	{
	padding-top: 0.5em;
	padding-bottom: 0.5em;
}
.notFirst	{
	padding-top: 0.5em;
	padding-bottom: 0.5em;
	border-top: 1px solid LightGray;
}
.countCell	{
	padding-left: 3em;
}
.commentCell	{
	padding-left: 1em;
	padding-bottom: 1em;
	line-height: 0.5em;
}

-->
</style>

<div class="panel" style="width: 93%; margin-top: 1em; line-height: 1.5em;">

<div class="title" style="text-align: center; margin-top: 0.5em;">Campinas </div>







<div class="panelHeader">Basic information</div>
<div class="panelHeaderRight"></div>
<div class="panel panelFloat myPanel">
<div class="comment"><b>Sample name</b>: Campinas</div><br>



<div class="comment"><span class="field"><b>Reference:</b></span> <span class="value">C. L. B. Sant Anna, D. B. Ribeiro, L. C. Garcia,  and A. V. L. Freitas. 2014. Fruit-feeding butterfly communities are influenced by restoration age in tropical forests. <i>Restoration Ecology</i> <b>22</b>(4):480-485 [ER 885]</span></div>

</div>

<div class="panelHeader">Geography</div>
<div class="panelHeaderRight"></div>
<div class="panel panelFloat myPanel">
<div style="float: left; clear: none; width: 50%;">
<div class="comment"><b>Country</b>: Brazil</div><br>

<div class="comment"><b>State</b>: S&#228;o Paulo</div><br>
<br>
<span class="not_comment"><span class="field">Coordinate:</span> <span class="value">22&deg; 50' 5" S, 46&deg; 55' 38" W</span></span>
<br>
<div class="comment"><b>Coordinate basis</b>: stated in text</div><br>












<div class="comment"><b>Geography comments</b>: elevation 554 to 711 m</div><br>

</div>

<div style="position: relative; float: left; clear: right; margin-left: 2em; height: 180px; width: 270px; overflow: hidden;">
<img src="images/large_world_map.png" style="position: absolute; bottom: -27px; left: -65px; height: 360px;">
<div style="position: absolute; bottom: 80px; left: 125px;"><span style="font-size: 30px; color: DodgerBlue;">&bull;</span></div>
</div>

</div>

<div class="panelHeader">Environment</div>
<div class="panelHeaderRight"></div>
<div class="panel panelFloat myPanel">
<div class="comment"><b>Habitat</b>: tropical/subtropical dry broadleaf forest</div><br>



<div class="comment"><b>Substrate</b>: ground surface</div><br>





<div class="comment"><b>MAT</b>: 20.6</div><br>




<div class="comment"><b>MAP</b>: 1360.0</div><br>


<div class="comment"><b>Habitat comments</b>: native "seasonal semi-deciduous Atlantic Forest"<br>
climate data are for Campinas and are from Chiarello (1993, Primates)</div><br>

</div>

<div class="panelHeader">Methods</div>
<div class="panelHeaderRight"></div>
<div class="panel panelFloat myPanel">
<div class="comment"><b>Life forms</b>: butterflies</div><br>


<div class="comment"><b>Sites</b>: 3</div><br>


<div class="comment"><b>Site length</b>: 450</div><br>


<div class="comment"><b>Sampling methods</b>: line transect,baited</div><br>

<div class="comment"><b>Sample size</b>: 123 individuals</div><br>



<div class="comment"><b>Days</b>: 32</div><br>


<div class="comment"><b>Nets or traps</b>: 15</div><br>

<div class="comment"><b>Net or trap nights</b>: 480</div><br>






<div class="comment"><b>Sampling comments</b>: "three sampling units, 200m apart from each other and at least 10m from the forest edge" each including "five Van Someren-Rydon portable traps... arranged linearly 30 m apart" each baited with banana and sugar cane juice and opened for eight days a month over four months</div><br>

</div>

<div class="panelHeader">Metadata</div>
<div class="panelHeaderRight"></div>
<div class="panel panelFloat myPanel">
<div class="comment"><b>Sample number</b>: 1325</div><br>

<div class="comment"><b>Contributor</b>: John Alroy</div><br>

<div class="comment"><b>Enterer</b>: John Alroy</div><br>


<div class="comment"><b>Created</b>: 2015-02-21 12:36:28</div><br>

<div class="comment"><b>Modified</b>: 2016-12-13 10:17:31</div><br>

</div>

<div style="float: left; clear: none; display: block;">
<div class="panelHeader">Abundance distribution</div>
<div class="panelHeaderRight"></div>

<div class="panel panelFloat myPanel" style="height: 360px;">
<div style="position: absolute; float: left; clear: none; margin-top: 10px; width: 300px;">
<div style="position: absolute; left: 0; top: 10; width: 143.792985796344; height: 143.792985796344; background-color: hsl(0,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 217.372929685229; top: 227.372929685229; width: 122.627070314771; height: 122.627070314771; background-color: hsl(12.8571428571429,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 0; top: 253.054788752926; width: 96.9452112470742; height: 96.9452112470742; background-color: hsl(25.7142857142857,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 243.054788752926; top: 10; width: 96.9452112470742; height: 96.9452112470742; background-color: hsl(38.5714285714286,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 102.408480699924; top: 233.762934917577; width: 86.710432976614; height: 86.710432976614; background-color: hsl(51.4285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 202.326757086951; top: 103.003984195778; width: 81.1101830143286; height: 81.1101830143286; background-color: hsl(64.2857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 23.1737432830811; top: 209.232818986023; width: 75.0934377308957; height: 75.0934377308957; background-color: hsl(77.1428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 166.08492293608; top: 34.9195763246835; width: 68.5506162763685; height: 68.5506162763685; background-color: hsl(90,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 69.5233479584395; top: 178.940674652741; width: 61.3135351573854; height: 61.3135351573854; background-color: hsl(102.857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 249.38826130559; top: 79.1419535370242; width: 61.3135351573854; height: 61.3135351573854; background-color: hsl(115.714285714286,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 109.365746863449; top: 10; width: 61.3135351573854; height: 61.3135351573854; background-color: hsl(128.571428571429,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 259.348861031843; top: 164.671616210654; width: 61.3135351573854; height: 61.3135351573854; background-color: hsl(141.428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 114.346046726575; top: 72.0074243159805; width: 61.3135351573854; height: 61.3135351573854; background-color: hsl(154.285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 220.82379890848; top: 204.654487703183; width: 43.355216488307; height: 43.355216488307; background-color: hsl(167.142857142857,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 293.947743544005; top: 96.4884397295148; width: 43.355216488307; height: 43.355216488307; background-color: hsl(180,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 296.644783511693; top: 212.405415742681; width: 43.355216488307; height: 43.355216488307; background-color: hsl(192.857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 137.48358763377; top: 299.343147752555; width: 43.355216488307; height: 43.355216488307; background-color: hsl(205.714285714286,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 24.4619151801345; top: 150.181994209008; width: 30.6567675786927; height: 30.6567675786927; background-color: hsl(218.571428571429,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 174.566765695394; top: 288.549210710242; width: 30.6567675786927; height: 30.6567675786927; background-color: hsl(231.428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 287.145403581839; top: 141.610413460448; width: 30.6567675786927; height: 30.6567675786927; background-color: hsl(244.285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 309.343232421307; top: 238.141014835551; width: 30.6567675786927; height: 30.6567675786927; background-color: hsl(257.142857142857,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 147.00742431598; top: 55.5389658668779; width: 30.6567675786927; height: 30.6567675786927; background-color: hsl(270,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 25.2555682369854; top: 195.105291038766; width: 30.6567675786927; height: 30.6567675786927; background-color: hsl(282.857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 174.963592223819; top: 94.8884536247097; width: 30.6567675786927; height: 30.6567675786927; background-color: hsl(295.714285714286,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 79.8176042172366; top: 274.725825564168; width: 30.6567675786927; height: 30.6567675786927; background-color: hsl(308.571428571429,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 202.244610213945; top: 319.343232421307; width: 30.6567675786927; height: 30.6567675786927; background-color: hsl(321.428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 93.4581132122994; top: 319.343232421307; width: 30.6567675786927; height: 30.6567675786927; background-color: hsl(334.285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 39.0648647114765; top: 157.00742431598; width: 30.6567675786927; height: 30.6567675786927; background-color: hsl(347.142857142857,80%,50%); opacity: 0.5;"></div>

</div>
<div style="float: left; clear: none; margin-top: 20px; margin-left: 300px; width: 20em; padding-left: 6em;">
<div>
<div>28 species</div>
<div>11 singletons</div>
<div>total count 123</div>
<div>extrapolated richness: 61.2</div>
<div>Fisher's &alpha;: 11.319</div>
<div>geometric series <i>k</i>: 0.8918</div>
<div>Hurlbert's PIE: 0.9186</div>
<div>Shannon's H: 2.8549</div>
<div>Good's <i>u</i>: 0.9111</div>
</div>
</div>

</div>

<div style="float: left; clear: both; padding-left: 1em; font-size: 0.9em;">
<i>Each square represents a species. Square sizes are proportional to counts.</i>
</div>

<div style="float: left; clear: both; padding-left: 2em; margin-bottom: 2em;">

<form method="POST" action="">
<input type="hidden" name="a" value="showMatches">
<input type="hidden" name="sample_no" value="1325">
</form>
<div class="mockLink" style="float: left; clear: left;" onClick="document.forms[1].submit();">&bull; Find matching samples</div>


<form method="POST" action="">
<input type="hidden" name="a" value="mapMatches">
<input type="hidden" name="sample_no" value="1325">
<div class="mockLink" style="float: left; clear: right;" onClick="document.forms[2].submit();">&bull; Map matching samples</div>
</form>


<form method="POST" action="">
<input type="hidden" name="a" value="statsPage">
<input type="hidden" name="sample" value="1325">
<div class="mockLink" style="float: left; clear: none;" onClick="document.forms[3].submit();">&bull; Extrapolate richness estimates</div>
</form>
</div>

</div>

<div class="panelHeader">Register</div>
<div class="panelHeaderRight"></div>
<div class="panel panelFloat myPanel">
<table style="border-collapse: collapse; font-size: 0.95em;">
<tr><td class="first"><a href="?a=taxonPage&amp;genus=Catonephele&amp;species=acontius"><i>Catonephele</i> <i>acontius</i></a></td><td class="countCell first">1</td><td class="countCell first"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Catonephele&amp;species=numilia"><i>Catonephele</i> <i>numilia</i></a></td><td class="countCell notFirst">6</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Epiphile&amp;species=hubneri"><i>Epiphile</i> <i>hubneri</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Hamadryas&amp;species=amphinome"><i>Hamadryas</i> <i>amphinome</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Hamadryas&amp;species=arete"><i>Hamadryas</i> <i>arete</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Hamadryas&amp;species=epinome"><i>Hamadryas</i> <i>epinome</i></a></td><td class="countCell notFirst">10</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Hamadryas&amp;species=februa"><i>Hamadryas</i> <i>februa</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Hamadryas&amp;species=feronia"><i>Hamadryas</i> <i>feronia</i></a></td><td class="countCell notFirst">4</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Hamadryas&amp;species=iphthime"><i>Hamadryas</i> <i>iphthime</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Myscelia&amp;species=orsis"><i>Myscelia</i> <i>orsis</i></a></td><td class="countCell notFirst">7</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Temenis&amp;species=laothoe"><i>Temenis</i> <i>laothoe</i></a></td><td class="countCell notFirst">2</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Moneuptychia&amp;species=soter"><i>Moneuptychia</i> <i>soter</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Pareuptychia&amp;species=ocirrhoe"><i>Pareuptychia</i> <i>ocirrhoe</i></a></td><td class="countCell notFirst">16</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Taygetis&amp;species=laches"><i>Taygetis</i> <i>laches</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Taygetis&amp;species=virgilia"><i>Taygetis</i> <i>virgilia</i></a></td><td class="countCell notFirst">10</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Catoblepia&amp;species=berecynthia"><i>Catoblepia</i> <i>berecynthia</i></a></td><td class="countCell notFirst">2</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Opoptera&amp;species=syme"><i>Opoptera</i> <i>syme</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Opsiphanes&amp;species=invirae"><i>Opsiphanes</i> <i>invirae</i></a></td><td class="countCell notFirst">4</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Opsiphanes&amp;species=quiteria"><i>Opsiphanes</i> <i>quiteria</i></a></td><td class="countCell notFirst">2</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Morpho&amp;species=helenor"><i>Morpho</i> <i>helenor</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Colobura&amp;species=dirce"><i>Colobura</i> <i>dirce</i></a></td><td class="countCell notFirst">5</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Smyrna&amp;species=blomfildia"><i>Smyrna</i> <i>blomfildia</i></a></td><td class="countCell notFirst">22</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Archaeoprepona&amp;species=amphimachus"><i>Archaeoprepona</i> <i>amphimachus</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Archaeoprepona&amp;species=chalciope"><i>Archaeoprepona</i> <i>chalciope</i></a></td><td class="countCell notFirst">8</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Archaeoprepona&amp;species=demophon"><i>Archaeoprepona</i> <i>demophon</i></a></td><td class="countCell notFirst">4</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Fountainea&amp;species=ryphea"><i>Fountainea</i> <i>ryphea</i></a></td><td class="countCell notFirst">4</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Hypna&amp;species=clytemnestra"><i>Hypna</i> <i>clytemnestra</i></a></td><td class="countCell notFirst">4</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Memphis&amp;species=moruus"><i>Memphis</i> <i>moruus</i></a></td><td class="countCell notFirst">2</td><td class="countCell notFirst"></td></tr>

</table>
</div>

</div>

<div style="clear: both; margin-left: auto; margin-right: auto; width: 100%; padding-top: 0.5em; padding-bottom: 0.5em; border-top: 1px solid WhiteSmoke; text-align: center; font-size: 1.2em;">


</div>

</div>

</body>
</html>