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=164 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=164SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=60SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=164 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alphitonia' AND (junior_species='zizyphoides' OR junior_species='zizyphoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alphitonia' AND (species='zizyphoides' OR species='zizyphoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alphitonia' AND (species='zizyphoides' OR species='zizyphoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alphitonia' AND (junior_species='zizyphoides' OR junior_species='zizyphoides')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='Alphitonia' AND (species='zizyphoides' OR species='zizyphoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Barringtonia' AND (junior_species='samoensis' OR junior_species='samoensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Barringtonia' AND (species='samoensis' OR species='samoensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Barringtonia' AND (species='samoensis' OR species='samoensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Barringtonia' AND (junior_species='samoensis' OR junior_species='samoensis')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='Barringtonia' AND (species='samoensis' OR species='samoensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bischofia' AND (junior_species='javanica' OR junior_species='javanica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bischofia' AND (species='javanica' OR species='javanica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bischofia' AND (species='javanica' OR species='javanica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bischofia' AND (junior_species='javanica' OR junior_species='javanica')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='Bischofia' AND (species='javanica' OR species='javanica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buchanania' AND (junior_species='merillii' OR junior_species='merilli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Buchanania' AND (species='merillii' OR species='merilli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Buchanania' AND (species='merillii' OR species='merilli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buchanania' AND (junior_species='merillii' OR junior_species='merilli')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='Buchanania' AND (species='merillii' OR species='merilli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canarium' AND (junior_species='harveyi' OR junior_species='harveyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canarium' AND (species='harveyi' OR species='harveyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canarium' AND (species='harveyi' OR species='harveyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canarium' AND (junior_species='harveyi' OR junior_species='harveyii')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='Canarium' AND (species='harveyi' OR species='harveyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthium' AND (junior_species='merillii' OR junior_species='merilli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthium' AND (species='merillii' OR species='merilli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthium' AND (species='merillii' OR species='merilli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthium' AND (junior_species='merillii' OR junior_species='merilli')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='Canthium' AND (species='merillii' OR species='merilli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cananga' AND (junior_species='odorata' OR junior_species='odorata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cananga' AND (species='odorata' OR species='odorata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cananga' AND (species='odorata' OR species='odorata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cananga' AND (junior_species='odorata' OR junior_species='odorata')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='Cananga' AND (species='odorata' OR species='odorata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canarium' AND (junior_species='vitiense' OR junior_species='vitiense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canarium' AND (species='vitiense' OR species='vitiense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canarium' AND (species='vitiense' OR species='vitiense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canarium' AND (junior_species='vitiense' OR junior_species='vitiense')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='Canarium' AND (species='vitiense' OR species='vitiense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crossostylos' AND (junior_species='biflora' OR junior_species='biflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crossostylos' AND (species='biflora' OR species='biflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crossostylos' AND (species='biflora' OR species='biflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crossostylos' AND (junior_species='biflora' OR junior_species='biflora')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='Crossostylos' AND (species='biflora' OR species='biflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='samoensis' OR junior_species='samoensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='samoensis' OR species='samoensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='samoensis' OR species='samoensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='samoensis' OR junior_species='samoensis')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='Diospyros' AND (species='samoensis' OR species='samoensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' AND (junior_species='huntii' OR junior_species='hunti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dysoxylum' AND (species='huntii' OR species='hunti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dysoxylum' AND (species='huntii' OR species='hunti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' AND (junior_species='huntii' OR junior_species='hunti')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='Dysoxylum' AND (species='huntii' OR species='hunti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' AND (junior_species='maota' OR junior_species='maota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dysoxylum' AND (species='maota' OR species='maota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dysoxylum' AND (species='maota' OR species='maota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' AND (junior_species='maota' OR junior_species='maota')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='Dysoxylum' AND (species='maota' OR species='maota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' AND (junior_species='samoensis' OR junior_species='samoensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dysoxylum' AND (species='samoensis' OR species='samoensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dysoxylum' AND (species='samoensis' OR species='samoensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' AND (junior_species='samoensis' OR junior_species='samoensis')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='Dysoxylum' AND (species='samoensis' OR species='samoensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='ulianus' OR junior_species='ulianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeocarpus' AND (species='ulianus' OR species='ulianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaeocarpus' AND (species='ulianus' OR species='ulianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='ulianus' OR junior_species='ulianus')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='Elaeocarpus' AND (species='ulianus' OR species='ulianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='godeffroyi' OR junior_species='godeffroyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='godeffroyi' OR species='godeffroyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='godeffroyi' OR species='godeffroyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='godeffroyi' OR junior_species='godeffroyii')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='Ficus' AND (species='godeffroyi' OR species='godeffroyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='uniauriculata' OR junior_species='uniauriculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='uniauriculata' OR species='uniauriculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='uniauriculata' OR species='uniauriculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='uniauriculata' OR junior_species='uniauriculata')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='Ficus' AND (species='uniauriculata' OR species='uniauriculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' 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='Ficus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' 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='Ficus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Flacourtia' AND (junior_species='rukam' OR junior_species='rukam')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Flacourtia' AND (species='rukam' OR species='rukam') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Flacourtia' AND (species='rukam' OR species='rukam')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Flacourtia' AND (junior_species='rukam' OR junior_species='rukam')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='Flacourtia' AND (species='rukam' OR species='rukam') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hernandia' AND (junior_species='moerenhoutiana' OR junior_species='moerenhoutiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hernandia' AND (species='moerenhoutiana' OR species='moerenhoutiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hernandia' AND (species='moerenhoutiana' OR species='moerenhoutiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hernandia' AND (junior_species='moerenhoutiana' OR junior_species='moerenhoutiana')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='Hernandia' AND (species='moerenhoutiana' OR species='moerenhoutiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inocarpus' AND (junior_species='fagifer' OR junior_species='fagifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inocarpus' AND (species='fagifer' OR species='fagifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inocarpus' AND (species='fagifer' OR species='fagifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inocarpus' AND (junior_species='fagifer' OR junior_species='fagifer')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='Inocarpus' AND (species='fagifer' OR species='fagifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='stipulosa' OR junior_species='stipulosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaranga' AND (species='stipulosa' OR species='stipulosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macaranga' AND (species='stipulosa' OR species='stipulosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='stipulosa' OR junior_species='stipulosa')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='Macaranga' AND (species='stipulosa' OR species='stipulosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='fatua' OR junior_species='fatua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myristica' AND (species='fatua' OR species='fatua') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myristica' AND (species='fatua' OR species='fatua')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='fatua' OR junior_species='fatua')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='Myristica' AND (species='fatua' OR species='fatua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='hypargyraea' OR junior_species='hypargyraea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myristica' AND (species='hypargyraea' OR species='hypargyraea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myristica' AND (species='hypargyraea' OR species='hypargyraea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='hypargyraea' OR junior_species='hypargyraea')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='Myristica' AND (species='hypargyraea' OR species='hypargyraea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neonauclea' AND (junior_species='forsteri' OR junior_species='forsterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neonauclea' AND (species='forsteri' OR species='forsterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neonauclea' AND (species='forsteri' OR species='forsterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neonauclea' AND (junior_species='forsteri' OR junior_species='forsterii')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='Neonauclea' AND (species='forsteri' OR species='forsterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Planchonella' AND (junior_species='samoensis' OR junior_species='samoensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Planchonella' AND (species='samoensis' OR species='samoensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Planchonella' AND (species='samoensis' OR species='samoensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Planchonella' AND (junior_species='samoensis' OR junior_species='samoensis')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='Planchonella' AND (species='samoensis' OR species='samoensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='samarangense' OR junior_species='samarangense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='samarangense' OR species='samarangense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='samarangense' OR species='samarangense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='samarangense' OR junior_species='samarangense')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='Syzygium' AND (species='samarangense' OR species='samarangense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='samoense' OR junior_species='samoense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='samoense' OR species='samoense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='samoense' OR species='samoense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='samoense' OR junior_species='samoense')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='Syzygium' AND (species='samoense' OR species='samoense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='catappa' OR junior_species='catappa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='catappa' OR species='catappa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='catappa' OR species='catappa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='catappa' OR junior_species='catappa')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='Terminalia' AND (species='catappa' OR species='catappa') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=164<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<title>
The Ecological Register: Tutuila (valley)
</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;">Tutuila (valley) </div>







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



<div class="comment"><span class="field"><b>Reference:</b></span> <span class="value">E. L. Webb, B. J. Stanfield,  and M. L. Jensen. 1999. Effects of topography on rainforest tree community structure and diversity in American Samoa, and implications for frugivore and nectarivore populations. <i>Journal of Biogeography</i> <b>26</b>(4):887-897 [ER 60]</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>: United States</div><br>

<div class="comment"><b>State</b>: American Samoa</div><br>
<br>
<span class="not_comment"><span class="field">Coordinate:</span> <span class="value">14&deg; 18' S, 170&deg; 41' E</span></span>
<br>
<div class="comment"><b>Coordinate basis</b>: stated in text</div><br>












<div class="comment"><b>Geography comments</b>: "Plots ranged from 48 m to 339 m in elevation"</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: -50px; left: -391px; 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 moist broadleaf forest</div><br>



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




<div class="comment"><b>Disturbance</b>: recent storm</div><br>








</div>

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


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

<div class="comment"><b>Site area</b>: 0.4</div><br>




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










<div class="comment"><b>Size min</b>: 10</div><br>

<div class="comment"><b>Basal area</b>: 12.8</div><br>

<div class="comment"><b>Sampling comments</b>: twenty 10 x 20 m plots</div><br>

</div>

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

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

<div class="comment"><b>Enterer</b>: Albert Garcia Selles</div><br>


<div class="comment"><b>Created</b>: 2013-03-08 11:23:44</div><br>

<div class="comment"><b>Modified</b>: 2017-11-11 02:46:15</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: 164.744862029799; height: 164.744862029799; background-color: hsl(0,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 230.170091980134; top: 240.170091980134; width: 109.829908019866; height: 109.829908019866; background-color: hsl(12.8571428571429,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 0; top: 242.482559554275; width: 107.517440445725; height: 107.517440445725; background-color: hsl(25.7142857142857,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 234.845868819395; top: 10; width: 105.154131180605; height: 105.154131180605; background-color: hsl(38.5714285714286,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 91.1344016145464; top: 225.567200807273; width: 105.154131180605; height: 105.154131180605; background-color: hsl(51.4285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 203.024997233453; top: 105.241396829817; width: 77.6614727379418; height: 77.6614727379418; background-color: hsl(64.2857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 265.644800772415; top: 209.858466985601; width: 74.3551992275854; height: 74.3551992275854; background-color: hsl(77.1428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 265.644800772415; top: 91.3404336859043; width: 74.3551992275854; height: 74.3551992275854; background-color: hsl(90,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 42.0771959533667; top: 205.630612506663; width: 67.2568082863703; height: 67.2568082863703; background-color: hsl(102.857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 180.395323043309; top: 39.8572771574957; width: 54.9149540099329; height: 54.9149540099329; background-color: hsl(115.714285714286,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 246.468923019172; top: 181.199900076265; width: 54.9149540099329; height: 54.9149540099329; background-color: hsl(128.571428571429,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 114.544263916612; top: 37.245408174851; width: 44.8378721909135; height: 44.8378721909135; background-color: hsl(141.428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 11.8218639075605; top: 182.413236039697; width: 44.8378721909135; height: 44.8378721909135; background-color: hsl(154.285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 167.705031817023; top: 88.0007178830915; width: 38.8307363689709; height: 38.8307363689709; background-color: hsl(167.142857142857,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 27.3647318158917; top: 209.292674849303; width: 38.8307363689709; height: 38.8307363689709; background-color: hsl(180,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 173.974681815703; top: 300.261642573962; width: 38.8307363689709; height: 38.8307363689709; background-color: hsl(192.857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 80.8424432600089; top: 318.294836519829; width: 31.7051634801707; height: 31.7051634801707; background-color: hsl(205.714285714286,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 207.138044452319; top: 327.581063904543; width: 22.4189360954568; height: 22.4189360954568; background-color: hsl(218.571428571429,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 298.377410077283; top: 163.185797928407; width: 22.4189360954568; height: 22.4189360954568; background-color: hsl(231.428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 317.581063904543; top: 80.9881649403395; width: 22.4189360954568; height: 22.4189360954568; background-color: hsl(244.285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 153.185797928407; top: 19.3399401992886; width: 22.4189360954568; height: 22.4189360954568; background-color: hsl(257.142857142857,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 70.9881649403395; top: 179.06523607578; width: 22.4189360954568; height: 22.4189360954568; background-color: hsl(270,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 199.889348446306; top: 258.927884014026; width: 22.4189360954568; height: 22.4189360954568; background-color: hsl(282.857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 94.3399401992886; top: 298.859207983149; width: 22.4189360954568; height: 22.4189360954568; background-color: hsl(295.714285714286,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 15.1778840140259; top: 148.82486996771; width: 22.4189360954568; height: 22.4189360954568; background-color: hsl(308.571428571429,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 171.984207983149; top: 36.2991164561313; width: 22.4189360954568; height: 22.4189360954568; background-color: hsl(321.428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 80.3873699677102; top: 187.544824204201; width: 22.4189360954568; height: 22.4189360954568; background-color: hsl(334.285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 204.588950959991; top: 93.1676780782365; width: 22.4189360954568; height: 22.4189360954568; 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 230</div>
<div>extrapolated richness: 55.6</div>
<div>Fisher's &alpha;: 8.356</div>
<div>geometric series <i>k</i>: 0.8627</div>
<div>Hurlbert's PIE: 0.8936</div>
<div>Shannon's H: 2.6293</div>
<div>Good's <i>u</i>: 0.9522</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="164">
</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="164">
<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="164">
<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=Alphitonia&amp;species=zizyphoides"><i>Alphitonia</i> <i>zizyphoides</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=Barringtonia&amp;species=samoensis"><i>Barringtonia</i> <i>samoensis</i></a></td><td class="countCell notFirst">11</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Bischofia&amp;species=javanica"><i>Bischofia</i> <i>javanica</i></a></td><td class="countCell notFirst">3</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Buchanania&amp;species=merillii"><i>Buchanania</i> <i>merillii</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=Canarium&amp;species=harveyi"><i>Canarium</i> <i>harveyi</i></a></td><td class="countCell notFirst">24</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Canthium&amp;species=merillii"><i>Canthium</i> <i>merillii</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=Cananga&amp;species=odorata"><i>Cananga</i> <i>odorata</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=Canarium&amp;species=vitiense"><i>Canarium</i> <i>vitiense</i></a></td><td class="countCell notFirst">12</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Crossostylos&amp;species=biflora"><i>Crossostylos</i> <i>biflora</i></a></td><td class="countCell notFirst">3</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Diospyros&amp;species=samoensis"><i>Diospyros</i> <i>samoensis</i></a></td><td class="countCell notFirst">3</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Dysoxylum&amp;species=huntii"><i>Dysoxylum</i> <i>huntii</i></a></td><td class="countCell notFirst">11</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Dysoxylum&amp;species=maota"><i>Dysoxylum</i> <i>maota</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=Dysoxylum&amp;species=samoensis"><i>Dysoxylum</i> <i>samoensis</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=Elaeocarpus&amp;species=ulianus"><i>Elaeocarpus</i> <i>ulianus</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=Ficus&amp;species=godeffroyi"><i>Ficus</i> <i>godeffroyi</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=Ficus&amp;species=uniauriculata"><i>Ficus</i> <i>uniauriculata</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=Ficus"><i>Ficus</i> <i>sp.</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=Flacourtia&amp;species=rukam"><i>Flacourtia</i> <i>rukam</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=Hernandia&amp;species=moerenhoutiana"><i>Hernandia</i> <i>moerenhoutiana</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=Inocarpus&amp;species=fagifer"><i>Inocarpus</i> <i>fagifer</i></a></td><td class="countCell notFirst">23</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Macaranga&amp;species=stipulosa"><i>Macaranga</i> <i>stipulosa</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=Myristica&amp;species=fatua"><i>Myristica</i> <i>fatua</i></a></td><td class="countCell notFirst">54</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Myristica&amp;species=hypargyraea"><i>Myristica</i> <i>hypargyraea</i></a></td><td class="countCell notFirst">9</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Neonauclea&amp;species=forsteri"><i>Neonauclea</i> <i>forsteri</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=Planchonella&amp;species=samoensis"><i>Planchonella</i> <i>samoensis</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=Syzygium&amp;species=samarangense"><i>Syzygium</i> <i>samarangense</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=Syzygium&amp;species=samoense"><i>Syzygium</i> <i>samoense</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=Terminalia&amp;species=catappa"><i>Terminalia</i> <i>catappa</i></a></td><td class="countCell notFirst">1</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>