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=838 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=838SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=476SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=838 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='megacephala' OR junior_species='megacephala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='megacephala' OR species='megacephala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='megacephala' OR species='megacephala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='megacephala' OR junior_species='megacephala')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='Pheidole' AND (species='megacephala' OR species='megacephala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' 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='Pheidole' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' 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='Pheidole' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='laevithorax' OR junior_species='laevithorax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='laevithorax' OR species='laevithorax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='laevithorax' OR species='laevithorax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='laevithorax' OR junior_species='laevithorax')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='Tetramorium' AND (species='laevithorax' OR species='laevithorax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='eminii' OR junior_species='emini')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='eminii' OR species='emini') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='eminii' OR species='emini')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='eminii' OR junior_species='emini')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='Tetramorium' AND (species='eminii' OR species='emini') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='umtaliense' OR junior_species='umtaliense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='umtaliense' OR species='umtaliense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='umtaliense' OR species='umtaliense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='umtaliense' OR junior_species='umtaliense')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='Tetramorium' AND (species='umtaliense' OR species='umtaliense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='notiale' OR junior_species='notiale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='notiale' OR species='notiale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='notiale' OR species='notiale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='notiale' OR junior_species='notiale')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='Tetramorium' AND (species='notiale' OR species='notiale') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' 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='Solenopsis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Solenopsis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' 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='Solenopsis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='notulum' OR junior_species='notulum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monomorium' AND (species='notulum' OR species='notulum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monomorium' AND (species='notulum' OR species='notulum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='notulum' OR junior_species='notulum')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='Monomorium' AND (species='notulum' OR species='notulum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='taedium' OR junior_species='taedium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monomorium' AND (species='taedium' OR species='taedium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monomorium' AND (species='taedium' OR species='taedium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='taedium' OR junior_species='taedium')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='Monomorium' AND (species='taedium' OR species='taedium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='delagoense' OR junior_species='delagoense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monomorium' AND (species='delagoense' OR species='delagoense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monomorium' AND (species='delagoense' OR species='delagoense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='delagoense' OR junior_species='delagoense')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='Monomorium' AND (species='delagoense' OR species='delagoense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='musicum' OR junior_species='musicum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monomorium' AND (species='musicum' OR species='musicum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monomorium' AND (species='musicum' OR species='musicum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='musicum' OR junior_species='musicum')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='Monomorium' AND (species='musicum' OR species='musicum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cardiocondyla' AND (junior_species='emery' OR junior_species='emery')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cardiocondyla' AND (species='emery' OR species='emery') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cardiocondyla' AND (species='emery' OR species='emery')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cardiocondyla' AND (junior_species='emery' OR junior_species='emery')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='Cardiocondyla' AND (species='emery' OR species='emery') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' 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='Camponotus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' 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='Camponotus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='cinctellus' OR junior_species='cinctellus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camponotus' AND (species='cinctellus' OR species='cinctellus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='cinctellus' OR species='cinctellus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='cinctellus' OR junior_species='cinctellus')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='Camponotus' AND (species='cinctellus' OR species='cinctellus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acantholepis' 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='Acantholepis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acantholepis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acantholepis' 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='Acantholepis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acantholepis' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acantholepis' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acantholepis' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acantholepis' AND (junior_species='capensis' OR junior_species='capensis')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='Acantholepis' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acantholepis' 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='Acantholepis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acantholepis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acantholepis' 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='Acantholepis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratrechina' AND (junior_species='natalensis' OR junior_species='natalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paratrechina' AND (species='natalensis' OR species='natalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paratrechina' AND (species='natalensis' OR species='natalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratrechina' AND (junior_species='natalensis' OR junior_species='natalensis')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='Paratrechina' AND (species='natalensis' OR species='natalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Technomyrmex' AND (junior_species='albipes' OR junior_species='albipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Technomyrmex' AND (species='albipes' OR species='albipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Technomyrmex' AND (species='albipes' OR species='albipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Technomyrmex' AND (junior_species='albipes' OR junior_species='albipes')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='Technomyrmex' AND (species='albipes' OR species='albipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plectroctena' AND (junior_species='conjugata' OR junior_species='conjugata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plectroctena' AND (species='conjugata' OR species='conjugata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plectroctena' AND (species='conjugata' OR species='conjugata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plectroctena' AND (junior_species='conjugata' OR junior_species='conjugata')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='Plectroctena' AND (species='conjugata' OR species='conjugata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='rotundata' OR junior_species='rotundata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='rotundata' OR species='rotundata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='rotundata' OR species='rotundata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='rotundata' OR junior_species='rotundata')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='Pachycondyla' AND (species='rotundata' OR species='rotundata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerapachys' AND (junior_species='wroughtoni' OR junior_species='wroughtonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cerapachys' AND (species='wroughtoni' OR species='wroughtonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cerapachys' AND (species='wroughtoni' OR species='wroughtonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerapachys' AND (junior_species='wroughtoni' OR junior_species='wroughtonii')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='Cerapachys' AND (species='wroughtoni' OR species='wroughtonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formicidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formicidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicidae' AND (junior_species='indet.' OR junior_species='indet.')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='Formicidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formicidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formicidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicidae' AND (junior_species='indet.' OR junior_species='indet.')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='Formicidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formicidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formicidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicidae' AND (junior_species='indet.' OR junior_species='indet.')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='Formicidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formicidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formicidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicidae' AND (junior_species='indet.' OR junior_species='indet.')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='Formicidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formicidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formicidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicidae' AND (junior_species='indet.' OR junior_species='indet.')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='Formicidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formicidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formicidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicidae' AND (junior_species='indet.' OR junior_species='indet.')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='Formicidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=838<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<title>
The Ecological Register: N3 Highway
</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;">N3 Highway </div>







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



<div class="comment"><span class="field"><b>Reference:</b></span> <span class="value">M. J. Samways, R. Osborn,  and F. Carliel. 1997. Effect of a highway on ant (Hymenoptera: Formicidae) species composition and abundance, with a recommendation for roadside verge width. <i>Biodiversity and Conservation</i> <b>6</b>:903-913 [ER 476]</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>: South Africa</div><br>

<div class="comment"><b>State</b>: Kwazulu-Natal</div><br>
<br>
<span class="not_comment"><span class="field">Coordinate:</span> <span class="value">30&deg; 24' S, 29&deg; 37' E</span></span>
<br>
<div class="comment"><b>Coordinate basis</b>: stated in text</div><br>












<div class="comment"><b>Geography comments</b>: "on the N3 highway bypassing Pietermaritzburg"</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: -7px; left: -179px; 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 savanna</div><br>



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






<div class="comment"><b>WMT</b>: 24.6</div><br>

<div class="comment"><b>CMT</b>: 16.9</div><br>


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


<div class="comment"><b>Habitat comments</b>: "grassland savanna"<br>
climate based on station 68588 (Durban Airport)</div><br>

</div>

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


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




<div class="comment"><b>Sampling methods</b>: pitfall traps</div><br>

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


<div class="comment"><b>Years</b>: 1993</div><br>

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


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

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






<div class="comment"><b>Sampling comments</b>: three pitfall traps in a line 1 m apart set at six different distances from the highway at each of eight sites left out through the months of April and May and checked every four days</div><br>

</div>

<div class="panelHeader">Metadata</div>
<div class="panelHeaderRight"></div>
<div class="panel panelFloat myPanel">
<div class="comment"><b>Sample number</b>: 838</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>: 2014-04-18 21:11:17</div><br>

<div class="comment"><b>Modified</b>: 2015-10-03 22:48: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: 322.089255653763; height: 322.089255653763; background-color: hsl(0,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 263.264848053165; top: 273.264848053165; width: 76.7351519468346; height: 76.7351519468346; background-color: hsl(12.8571428571429,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 0; top: 315.614839821424; width: 34.385160178576; height: 34.385160178576; background-color: hsl(25.7142857142857,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 310.172478938768; top: 10; width: 29.8275210612318; height: 29.8275210612318; background-color: hsl(38.5714285714286,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 313.059465390173; top: 255.25817282774; width: 26.9405346098271; height: 26.9405346098271; background-color: hsl(51.4285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 314.857570281457; top: 62.1108951738917; width: 25.1424297185435; height: 25.1424297185435; background-color: hsl(64.2857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 321.259939343275; top: 32.9710246882194; width: 18.7400606567247; height: 18.7400606567247; background-color: hsl(77.1428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 322.892743415495; top: 187.616899216038; width: 17.1072565845053; height: 17.1072565845053; background-color: hsl(90,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 324.320940353694; top: 48.70310205392; width: 15.6790596463055; height: 15.6790596463055; background-color: hsl(102.857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 75.3895198179148; top: 13.9850602429712; width: 15.3011954525939; height: 15.3011954525939; background-color: hsl(115.714285714286,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 13.7065267998071; top: 10; width: 14.1070051724917; height: 14.1070051724917; background-color: hsl(128.571428571429,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 0; top: 10; width: 13.6858052676043; height: 13.6858052676043; background-color: hsl(141.428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 0; top: 260.085113673342; width: 13.2512239702173; height: 13.2512239702173; background-color: hsl(154.285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 0; top: 301.729750844117; width: 13.2512239702173; height: 13.2512239702173; background-color: hsl(167.142857142857,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 250.730275479781; top: 333.66271319081; width: 11.8522550329922; height: 11.8522550329922; background-color: hsl(180,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 58.7543112166743; top: 339.18042093521; width: 10.8195790647899; height: 10.8195790647899; background-color: hsl(192.857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 267.619573870366; top: 343.157097366198; width: 6.84290263380213; height: 6.84290263380213; background-color: hsl(205.714285714286,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 319.338804979916; top: 90.7231858538737; width: 6.84290263380213; height: 6.84290263380213; background-color: hsl(218.571428571429,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 332.268612757303; top: 218.650867268486; width: 6.84290263380213; height: 6.84290263380213; background-color: hsl(231.428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 333.157097366198; top: 112.614707975793; width: 6.84290263380213; height: 6.84290263380213; background-color: hsl(244.285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 334.073872483504; top: 230.055015888099; width: 5.92612751649609; height: 5.92612751649609; background-color: hsl(257.142857142857,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 334.073872483504; top: 118.545976064925; width: 5.92612751649609; height: 5.92612751649609; background-color: hsl(270,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 334.073872483504; top: 289.914196197545; width: 5.92612751649609; height: 5.92612751649609; background-color: hsl(282.857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 81.2961703021899; top: 332.7562512307; width: 5.92612751649609; height: 5.92612751649609; background-color: hsl(295.714285714286,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 39.1665532719709; top: 343.466764988989; width: 5.92612751649609; height: 5.92612751649609; background-color: hsl(308.571428571429,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 263.113072829874; top: 345.161337144639; width: 4.83866285536078; height: 4.83866285536078; background-color: hsl(321.428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 130.346870701097; top: 345.161337144639; width: 4.83866285536078; height: 4.83866285536078; background-color: hsl(334.285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 31.4808248737438; top: 346.578548683099; width: 3.42145131690107; height: 3.42145131690107; 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>1 singleton</div>
<div>total count 9875</div>
<div>extrapolated richness: 34.6</div>
<div>Fisher's &alpha;: 3.528</div>
<div>geometric series <i>k</i>: 0.7142</div>
<div>Hurlbert's PIE: 0.1917</div>
<div>Shannon's H: 0.5374</div>
<div>Good's <i>u</i>: 0.9999</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="838">
</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="838">
<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="838">
<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=Pheidole&amp;species=megacephala"><i>Pheidole</i> <i>megacephala</i></a></td><td class="countCell first">8862</td><td class="countCell first"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Pheidole"><i>Pheidole</i> <i>sp.</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=Tetramorium&amp;species=laevithorax"><i>Tetramorium</i> <i>laevithorax</i></a></td><td class="countCell notFirst">503</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Tetramorium&amp;species=eminii"><i>Tetramorium</i> <i>eminii</i></a></td><td class="countCell notFirst">15</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Tetramorium&amp;species=umtaliense"><i>Tetramorium</i> <i>umtaliense</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=Tetramorium&amp;species=notiale"><i>Tetramorium</i> <i>notiale</i></a></td><td class="countCell notFirst">17</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Solenopsis"><i>Solenopsis</i> <i>sp.</i></a></td><td class="countCell notFirst">21</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Monomorium&amp;species=notulum"><i>Monomorium</i> <i>notulum</i></a></td><td class="countCell notFirst">20</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Monomorium&amp;species=taedium"><i>Monomorium</i> <i>taedium</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=Monomorium&amp;species=delagoense"><i>Monomorium</i> <i>delagoense</i></a></td><td class="countCell notFirst">62</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Monomorium&amp;species=musicum"><i>Monomorium</i> <i>musicum</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=Cardiocondyla&amp;species=emery"><i>Cardiocondyla</i> <i>emery</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=Camponotus"><i>Camponotus</i> <i>sp.</i></a></td><td class="countCell notFirst">76</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Camponotus&amp;species=cinctellus"><i>Camponotus</i> <i>cinctellus</i></a></td><td class="countCell notFirst">101</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Acantholepis"><i>Acantholepis</i> <i>sp. 1</i></a></td><td class="countCell notFirst">30</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Acantholepis&amp;species=capensis"><i>Acantholepis</i> <i>capensis</i></a></td><td class="countCell notFirst">25</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Acantholepis"><i>Acantholepis</i> <i>sp. 2</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=Paratrechina&amp;species=natalensis"><i>Paratrechina</i> <i>natalensis</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=Technomyrmex&amp;species=albipes"><i>Technomyrmex</i> <i>albipes</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=Plectroctena&amp;species=conjugata"><i>Plectroctena</i> <i>conjugata</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=Pachycondyla&amp;species=rotundata"><i>Pachycondyla</i> <i>rotundata</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=Cerapachys&amp;species=wroughtoni"><i>Cerapachys</i> <i>wroughtoni</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=Formicidae">Formicidae indet. 1</a></td><td class="countCell notFirst">15</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Formicidae">Formicidae indet. 2</a></td><td class="countCell notFirst">4</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Formicidae">Formicidae indet. 3</a></td><td class="countCell notFirst">4</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Formicidae">Formicidae indet. 4</a></td><td class="countCell notFirst">3</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Formicidae">Formicidae indet. 5</a></td><td class="countCell notFirst">16</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Formicidae">Formicidae indet. 6</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>