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=428 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=428SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=205SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=428 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='conspicillatus' OR junior_species='conspicillatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplodactylus' AND (species='conspicillatus' OR species='conspicillatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplodactylus' AND (species='conspicillatus' OR species='conspicillatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='conspicillatus' OR junior_species='conspicillatus')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='Diplodactylus' AND (species='conspicillatus' OR species='conspicillatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='stenodactylus' OR junior_species='stenodactylus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplodactylus' AND (species='stenodactylus' OR species='stenodactylus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplodactylus' AND (species='stenodactylus' OR species='stenodactylus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='stenodactylus' OR junior_species='stenodactylus')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='Diplodactylus' AND (species='stenodactylus' OR species='stenodactylus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='tessellatus' OR junior_species='tessellatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplodactylus' AND (species='tessellatus' OR species='tessellatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplodactylus' AND (species='tessellatus' OR species='tessellatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='tessellatus' OR junior_species='tessellatus')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='Diplodactylus' AND (species='tessellatus' OR species='tessellatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteronotia' AND (junior_species='binoei' OR junior_species='binoeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteronotia' AND (species='binoei' OR species='binoeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteronotia' AND (species='binoei' OR species='binoeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteronotia' AND (junior_species='binoei' OR junior_species='binoeii')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='Heteronotia' AND (species='binoei' OR species='binoeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nephrurus' AND (junior_species='levis' OR junior_species='levis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nephrurus' AND (species='levis' OR species='levis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nephrurus' AND (species='levis' OR species='levis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nephrurus' AND (junior_species='levis' OR junior_species='levis')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='Nephrurus' AND (species='levis' OR species='levis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhynchoedura' AND (junior_species='ornata' OR junior_species='ornata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhynchoedura' AND (species='ornata' OR species='ornata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhynchoedura' AND (species='ornata' OR species='ornata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhynchoedura' AND (junior_species='ornata' OR junior_species='ornata')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='Rhynchoedura' AND (species='ornata' OR species='ornata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenophorus' AND (junior_species='fordi' OR junior_species='fordii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenophorus' AND (species='fordi' OR species='fordii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenophorus' AND (species='fordi' OR species='fordii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenophorus' AND (junior_species='fordi' OR junior_species='fordii')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='Ctenophorus' AND (species='fordi' OR species='fordii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenophorus' AND (junior_species='nuchalis' OR junior_species='nuchalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenophorus' AND (species='nuchalis' OR species='nuchalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenophorus' AND (species='nuchalis' OR species='nuchalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenophorus' AND (junior_species='nuchalis' OR junior_species='nuchalis')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='Ctenophorus' AND (species='nuchalis' OR species='nuchalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenophorus' AND (junior_species='pictus' OR junior_species='pictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenophorus' AND (species='pictus' OR species='pictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenophorus' AND (species='pictus' OR species='pictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenophorus' AND (junior_species='pictus' OR junior_species='pictus')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='Ctenophorus' AND (species='pictus' OR species='pictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogona' AND (junior_species='vitticeps' OR junior_species='vitticeps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pogona' AND (species='vitticeps' OR species='vitticeps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pogona' AND (species='vitticeps' OR species='vitticeps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogona' AND (junior_species='vitticeps' OR junior_species='vitticeps')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='Pogona' AND (species='vitticeps' OR species='vitticeps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tympanocryptis' AND (junior_species='intima' OR junior_species='intima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tympanocryptis' AND (species='intima' OR species='intima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tympanocryptis' AND (species='intima' OR species='intima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tympanocryptis' AND (junior_species='intima' OR junior_species='intima')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='Tympanocryptis' AND (species='intima' OR species='intima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tympanocryptis' AND (junior_species='lineata' OR junior_species='lineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tympanocryptis' AND (species='lineata' OR species='lineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tympanocryptis' AND (species='lineata' OR species='lineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tympanocryptis' AND (junior_species='lineata' OR junior_species='lineata')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='Tympanocryptis' AND (species='lineata' OR species='lineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tympanocryptis' AND (junior_species='tetraporophora' OR junior_species='tetraporophora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tympanocryptis' AND (species='tetraporophora' OR species='tetraporophora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tympanocryptis' AND (species='tetraporophora' OR species='tetraporophora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tympanocryptis' AND (junior_species='tetraporophora' OR junior_species='tetraporophora')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='Tympanocryptis' AND (species='tetraporophora' OR species='tetraporophora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='gouldii' OR junior_species='gouldi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Varanus' AND (species='gouldii' OR species='gouldi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Varanus' AND (species='gouldii' OR species='gouldi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='gouldii' OR junior_species='gouldi')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='Varanus' AND (species='gouldii' OR species='gouldi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='brooksi' OR junior_species='brooksii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenotus' AND (species='brooksi' OR species='brooksii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenotus' AND (species='brooksi' OR species='brooksii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='brooksi' OR junior_species='brooksii')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='Ctenotus' AND (species='brooksi' OR species='brooksii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='leae' OR junior_species='leae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenotus' AND (species='leae' OR species='leae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenotus' AND (species='leae' OR species='leae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='leae' OR junior_species='leae')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='Ctenotus' AND (species='leae' OR species='leae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='leonhardii' OR junior_species='leonhardi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenotus' AND (species='leonhardii' OR species='leonhardi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenotus' AND (species='leonhardii' OR species='leonhardi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='leonhardii' OR junior_species='leonhardi')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='Ctenotus' AND (species='leonhardii' OR species='leonhardi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='regius' OR junior_species='regius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenotus' AND (species='regius' OR species='regius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenotus' AND (species='regius' OR species='regius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='regius' OR junior_species='regius')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='Ctenotus' AND (species='regius' OR species='regius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='schomburgkii' OR junior_species='schomburgki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenotus' AND (species='schomburgkii' OR species='schomburgki') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenotus' AND (species='schomburgkii' OR species='schomburgki')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='schomburgkii' OR junior_species='schomburgki')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='Ctenotus' AND (species='schomburgkii' OR species='schomburgki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='strauchii' OR junior_species='strauchi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenotus' AND (species='strauchii' OR species='strauchi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenotus' AND (species='strauchii' OR species='strauchi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='strauchii' OR junior_species='strauchi')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='Ctenotus' AND (species='strauchii' OR species='strauchi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eremiasdncus' AND (junior_species='richardsonii' OR junior_species='richardsoni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eremiasdncus' AND (species='richardsonii' OR species='richardsoni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eremiasdncus' AND (species='richardsonii' OR species='richardsoni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eremiasdncus' AND (junior_species='richardsonii' OR junior_species='richardsoni')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='Eremiasdncus' AND (species='richardsonii' OR species='richardsoni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lerista' AND (junior_species='labialis' OR junior_species='labialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lerista' AND (species='labialis' OR species='labialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lerista' AND (species='labialis' OR species='labialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lerista' AND (junior_species='labialis' OR junior_species='labialis')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='Lerista' AND (species='labialis' OR species='labialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Menetia' AND (junior_species='greyii' OR junior_species='greyi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Menetia' AND (species='greyii' OR species='greyi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Menetia' AND (species='greyii' OR species='greyi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Menetia' AND (junior_species='greyii' OR junior_species='greyi')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='Menetia' AND (species='greyii' OR species='greyi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiliqua' AND (junior_species='rugosa' OR junior_species='rugosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tiliqua' AND (species='rugosa' OR species='rugosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tiliqua' AND (species='rugosa' OR species='rugosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiliqua' AND (junior_species='rugosa' OR junior_species='rugosa')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='Tiliqua' AND (species='rugosa' OR species='rugosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphotyphlops' AND (junior_species='endoterus' OR junior_species='endoterus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ramphotyphlops' AND (species='endoterus' OR species='endoterus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ramphotyphlops' AND (species='endoterus' OR species='endoterus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphotyphlops' AND (junior_species='endoterus' OR junior_species='endoterus')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='Ramphotyphlops' AND (species='endoterus' OR species='endoterus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudonaja' AND (junior_species='modesta' OR junior_species='modesta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudonaja' AND (species='modesta' OR species='modesta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudonaja' AND (species='modesta' OR species='modesta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudonaja' AND (junior_species='modesta' OR junior_species='modesta')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='Pseudonaja' AND (species='modesta' OR species='modesta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simoselaps' AND (junior_species='bertholdi' OR junior_species='bertholdii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Simoselaps' AND (species='bertholdi' OR species='bertholdii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Simoselaps' AND (species='bertholdi' OR species='bertholdii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simoselaps' AND (junior_species='bertholdi' OR junior_species='bertholdii')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='Simoselaps' AND (species='bertholdi' OR species='bertholdii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neobatrachus' AND (junior_species='centralis' OR junior_species='centralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neobatrachus' AND (species='centralis' OR species='centralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neobatrachus' AND (species='centralis' OR species='centralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neobatrachus' AND (junior_species='centralis' OR junior_species='centralis')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='Neobatrachus' AND (species='centralis' OR species='centralis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=428<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<title>
The Ecological Register: North of Roxby Downs
</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;">North of Roxby Downs </div>







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



<div class="comment"><span class="field"><b>Reference:</b></span> <span class="value">J. L. Read. 1995. Subhabitat variability: A key to the high reptile diversity in chenopod shrublands. <i>Australian Journal of Ecology</i> <b>29</b>:494-501 [ER 205]</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>: Australia</div><br>

<div class="comment"><b>State</b>: South Australia</div><br>
<br>
<span class="not_comment"><span class="field">Coordinate:</span> <span class="value">30&deg; 29' S, 136&deg; 53' E</span></span>
<br>
<div class="comment"><b>Coordinate basis</b>: stated in text</div><br>












<div class="comment"><b>Geography comments</b>: coordinate given in text</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: -340px; 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>: desert/xeric shrubland</div><br>

<div class="comment"><b>Altered habitat</b>: pasture</div><br>


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






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

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


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


<div class="comment"><b>Habitat comments</b>: "interdunal swale dominated by... perennial shrubs"<br>
MAP stated in text; CMT and WMT based on climate station 94659 (Woomera)</div><br>

</div>

<div class="panelHeader">Methods</div>
<div class="panelHeaderRight"></div>
<div class="panel panelFloat myPanel">
<div class="comment"><b>Life forms</b>: lizards,snakes,frogs</div><br>






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

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


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










<div class="comment"><b>Sampling comments</b>: 401 pitfall traps on a grid</div><br>

</div>

<div class="panelHeader">Metadata</div>
<div class="panelHeaderRight"></div>
<div class="panel panelFloat myPanel">
<div class="comment"><b>Sample number</b>: 428</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-03-16 15:30:19</div><br>

<div class="comment"><b>Modified</b>: 2014-05-04 06:27:28</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: 165.866785080718; height: 165.866785080718; background-color: hsl(0,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 212.654751847294; top: 222.654751847294; width: 127.345248152706; height: 127.345248152706; background-color: hsl(12.8571428571429,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 0; top: 225.409842188154; width: 124.590157811846; height: 124.590157811846; background-color: hsl(25.7142857142857,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 223.524277695037; top: 10; width: 116.475722304963; height: 116.475722304963; background-color: hsl(38.5714285714286,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 100.76796513886; top: 169.005826291342; width: 80.2262085697979; height: 80.2262085697979; background-color: hsl(51.4285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 200.52454761146; top: 69.6434781877007; width: 79.8319742008394; height: 79.8319742008394; background-color: hsl(64.2857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 262.575575657832; top: 191.067520472976; width: 77.4244243421684; height: 77.4244243421684; background-color: hsl(77.1428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 114.459172537399; top: 277.630557245883; width: 72.3694427541175; height: 72.3694427541175; background-color: hsl(90,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 265.143610956478; top: 134.390276789334; width: 55.0347250442726; height: 55.0347250442726; background-color: hsl(102.857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 122.171036428894; top: 231.794369345322; width: 48.3189006208258; height: 48.3189006208258; background-color: hsl(115.714285714286,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 268.085200103711; top: 109.479488246752; width: 46.9948431622321; height: 46.9948431622321; background-color: hsl(128.571428571429,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 127.161968348736; top: 22.1148849632898; width: 37.2586849873543; height: 37.2586849873543; background-color: hsl(141.428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 224.26631292753; top: 176.742771234806; width: 37.2586849873543; height: 37.2586849873543; background-color: hsl(154.285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 104.135200115816; top: 255.373429269454; width: 34.6252551895756; height: 34.6252551895756; background-color: hsl(167.142857142857,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 213.411286260514; top: 313.358886621273; width: 34.6252551895756; height: 34.6252551895756; background-color: hsl(180,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 99.4748002681069; top: 318.225686680912; width: 31.7743133190878; height: 31.7743133190878; background-color: hsl(192.857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 211.793821804281; top: 156.169265010684; width: 31.7743133190878; height: 31.7743133190878; background-color: hsl(205.714285714286,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 99.519999742584; top: 291.193615928228; width: 28.6409789786574; height: 28.6409789786574; background-color: hsl(218.571428571429,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 14.70144104691; top: 143.99837144771; width: 27.5173625221363; height: 27.5173625221363; background-color: hsl(231.428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 171.670161006971; top: 241.318626207371; width: 25.1198002940355; height: 25.1198002940355; background-color: hsl(244.285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 250.881114369258; top: 120.705346969458; width: 22.4678324154731; height: 22.4678324154731; background-color: hsl(257.142857142857,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 121.328658468612; top: 231.240774768712; width: 19.4577136397711; height: 19.4577136397711; background-color: hsl(270,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 226.647567079266; top: 58.8612173321672; width: 17.7623811299643; height: 17.7623811299643; background-color: hsl(282.857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 52.0028487805281; top: 201.991863318041; width: 13.7586812610682; height: 13.7586812610682; background-color: hsl(295.714285714286,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 193.824136601663; top: 54.1008428832754; width: 11.2339162077365; height: 11.2339162077365; background-color: hsl(308.571428571429,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 44.2433155725145; top: 199.241942389704; width: 11.2339162077365; height: 11.2339162077365; background-color: hsl(321.428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 190.958347673305; top: 273.4576610819; width: 7.94357832977196; height: 7.94357832977196; background-color: hsl(334.285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 263.49327925421; top: 139.742935958507; width: 7.94357832977196; height: 7.94357832977196; 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>2 singletons</div>
<div>total count 1832</div>
<div>extrapolated richness: 33.4</div>
<div>Fisher's &alpha;: 4.690</div>
<div>geometric series <i>k</i>: 0.7984</div>
<div>Hurlbert's PIE: 0.8786</div>
<div>Shannon's H: 2.4747</div>
<div>Good's <i>u</i>: 0.9989</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="428">
</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="428">
<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="428">
<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=Diplodactylus&amp;species=conspicillatus"><i>Diplodactylus</i> <i>conspicillatus</i></a></td><td class="countCell first">102</td><td class="countCell first"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Diplodactylus&amp;species=stenodactylus"><i>Diplodactylus</i> <i>stenodactylus</i></a></td><td class="countCell notFirst">95</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Diplodactylus&amp;species=tessellatus"><i>Diplodactylus</i> <i>tessellatus</i></a></td><td class="countCell notFirst">19</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Heteronotia&amp;species=binoei"><i>Heteronotia</i> <i>binoei</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=Nephrurus&amp;species=levis"><i>Nephrurus</i> <i>levis</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=Rhynchoedura&amp;species=ornata"><i>Rhynchoedura</i> <i>ornata</i></a></td><td class="countCell notFirst">257</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Ctenophorus&amp;species=fordi"><i>Ctenophorus</i> <i>fordi</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=Ctenophorus&amp;species=nuchalis"><i>Ctenophorus</i> <i>nuchalis</i></a></td><td class="countCell notFirst">48</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Ctenophorus&amp;species=pictus"><i>Ctenophorus</i> <i>pictus</i></a></td><td class="countCell notFirst">83</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Pogona&amp;species=vitticeps"><i>Pogona</i> <i>vitticeps</i></a></td><td class="countCell notFirst">35</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Tympanocryptis&amp;species=intima"><i>Tympanocryptis</i> <i>intima</i></a></td><td class="countCell notFirst">37</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Tympanocryptis&amp;species=lineata"><i>Tympanocryptis</i> <i>lineata</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=Tympanocryptis&amp;species=tetraporophora"><i>Tympanocryptis</i> <i>tetraporophora</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=Varanus&amp;species=gouldii"><i>Varanus</i> <i>gouldii</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=Ctenotus&amp;species=brooksi"><i>Ctenotus</i> <i>brooksi</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=Ctenotus&amp;species=leae"><i>Ctenotus</i> <i>leae</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=Ctenotus&amp;species=leonhardii"><i>Ctenotus</i> <i>leonhardii</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=Ctenotus&amp;species=regius"><i>Ctenotus</i> <i>regius</i></a></td><td class="countCell notFirst">215</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Ctenotus&amp;species=schomburgkii"><i>Ctenotus</i> <i>schomburgkii</i></a></td><td class="countCell notFirst">246</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Ctenotus&amp;species=strauchii"><i>Ctenotus</i> <i>strauchii</i></a></td><td class="countCell notFirst">19</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Eremiasdncus&amp;species=richardsonii"><i>Eremiasdncus</i> <i>richardsonii</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=Lerista&amp;species=labialis"><i>Lerista</i> <i>labialis</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=Menetia&amp;species=greyii"><i>Menetia</i> <i>greyii</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=Tiliqua&amp;species=rugosa"><i>Tiliqua</i> <i>rugosa</i></a></td><td class="countCell notFirst">13</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Ramphotyphlops&amp;species=endoterus"><i>Ramphotyphlops</i> <i>endoterus</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=Pseudonaja&amp;species=modesta"><i>Pseudonaja</i> <i>modesta</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=Simoselaps&amp;species=bertholdi"><i>Simoselaps</i> <i>bertholdi</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=Neobatrachus&amp;species=centralis"><i>Neobatrachus</i> <i>centralis</i></a></td><td class="countCell notFirst">436</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>