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=1664 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1664SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1141SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1664 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ateuchus' AND (junior_species='murrayi' OR junior_species='murrayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ateuchus' AND (species='murrayi' OR species='murrayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ateuchus' AND (species='murrayi' OR species='murrayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ateuchus' AND (junior_species='murrayi' OR junior_species='murrayii')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='Ateuchus' AND (species='murrayi' OR species='murrayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ateuchus' AND (junior_species='simplex' OR junior_species='simplex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ateuchus' AND (species='simplex' OR species='simplex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ateuchus' AND (species='simplex' OR species='simplex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ateuchus' AND (junior_species='simplex' OR junior_species='simplex')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='Ateuchus' AND (species='simplex' OR species='simplex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ateuchus' 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='Ateuchus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ateuchus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ateuchus' 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='Ateuchus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ateuchus' 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='Ateuchus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ateuchus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ateuchus' 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='Ateuchus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ateuchus' AND (junior_species='substriatus' OR junior_species='substriatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ateuchus' AND (species='substriatus' OR species='substriatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ateuchus' AND (species='substriatus' OR species='substriatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ateuchus' AND (junior_species='substriatus' OR junior_species='substriatus')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='Ateuchus' AND (species='substriatus' OR species='substriatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='aterrimum' OR junior_species='aterrimum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthidium' AND (species='aterrimum' OR species='aterrimum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthidium' AND (species='aterrimum' OR species='aterrimum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='aterrimum' OR junior_species='aterrimum')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='Canthidium' AND (species='aterrimum' OR species='aterrimum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='centrale' OR junior_species='centrale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthidium' AND (species='centrale' OR species='centrale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthidium' AND (species='centrale' OR species='centrale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='centrale' OR junior_species='centrale')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='Canthidium' AND (species='centrale' OR species='centrale') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='gerstaeckeri' OR junior_species='gerstaeckerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthidium' AND (species='gerstaeckeri' OR species='gerstaeckerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthidium' AND (species='gerstaeckeri' OR species='gerstaeckerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='gerstaeckeri' OR junior_species='gerstaeckerii')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='Canthidium' AND (species='gerstaeckeri' OR species='gerstaeckerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='ruficolle' OR junior_species='ruficolle')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthidium' AND (species='ruficolle' OR species='ruficolle') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthidium' AND (species='ruficolle' OR species='ruficolle')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='ruficolle' OR junior_species='ruficolle')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='Canthidium' AND (species='ruficolle' OR species='ruficolle') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='vulcanoae' OR junior_species='vulcanoae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthon' AND (species='vulcanoae' OR species='vulcanoae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='vulcanoae' OR species='vulcanoae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='vulcanoae' OR junior_species='vulcanoae')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='Canthon' AND (species='vulcanoae' OR species='vulcanoae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthon' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='bicolor' OR junior_species='bicolor')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='Canthon' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='triangularis' OR junior_species='triangularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthon' AND (species='triangularis' OR species='triangularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='triangularis' OR species='triangularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='triangularis' OR junior_species='triangularis')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='Canthon' AND (species='triangularis' OR species='triangularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='carinatum' OR junior_species='carinatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Deltochilum' AND (species='carinatum' OR species='carinatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Deltochilum' AND (species='carinatum' OR species='carinatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='carinatum' OR junior_species='carinatum')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='Deltochilum' AND (species='carinatum' OR species='carinatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='guyanense' OR junior_species='guyanense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Deltochilum' AND (species='guyanense' OR species='guyanense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Deltochilum' AND (species='guyanense' OR species='guyanense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='guyanense' OR junior_species='guyanense')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='Deltochilum' AND (species='guyanense' OR species='guyanense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='icarus' OR junior_species='icarus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Deltochilum' AND (species='icarus' OR species='icarus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Deltochilum' AND (species='icarus' OR species='icarus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='icarus' OR junior_species='icarus')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='Deltochilum' AND (species='icarus' OR species='icarus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='orbiculare' OR junior_species='orbiculare')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Deltochilum' AND (species='orbiculare' OR species='orbiculare') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Deltochilum' AND (species='orbiculare' OR species='orbiculare')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='orbiculare' OR junior_species='orbiculare')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='Deltochilum' AND (species='orbiculare' OR species='orbiculare') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='septemstriatum' OR junior_species='septemstriatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Deltochilum' AND (species='septemstriatum' OR species='septemstriatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Deltochilum' AND (species='septemstriatum' OR species='septemstriatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='septemstriatum' OR junior_species='septemstriatum')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='Deltochilum' AND (species='septemstriatum' OR species='septemstriatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='submetallicum' OR junior_species='submetallicum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Deltochilum' AND (species='submetallicum' OR species='submetallicum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Deltochilum' AND (species='submetallicum' OR species='submetallicum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='submetallicum' OR junior_species='submetallicum')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='Deltochilum' AND (species='submetallicum' OR species='submetallicum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='apicalis' OR junior_species='apicalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Deltochilum' AND (species='apicalis' OR species='apicalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Deltochilum' AND (species='apicalis' OR species='apicalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='apicalis' OR junior_species='apicalis')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='Deltochilum' AND (species='apicalis' OR species='apicalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='boreus' OR junior_species='boreus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Deltochilum' AND (species='boreus' OR species='boreus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Deltochilum' AND (species='boreus' OR species='boreus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='boreus' OR junior_species='boreus')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='Deltochilum' AND (species='boreus' OR species='boreus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='robustus' OR junior_species='robustus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Deltochilum' AND (species='robustus' OR species='robustus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Deltochilum' AND (species='robustus' OR species='robustus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='robustus' OR junior_species='robustus')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='Deltochilum' AND (species='robustus' OR species='robustus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' 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='Deltochilum' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Deltochilum' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' 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='Deltochilum' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='subaeneus' OR junior_species='subaeneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Deltochilum' AND (species='subaeneus' OR species='subaeneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Deltochilum' AND (species='subaeneus' OR species='subaeneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='subaeneus' OR junior_species='subaeneus')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='Deltochilum' AND (species='subaeneus' OR species='subaeneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='balachowskyi' OR junior_species='balachowskyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurysternus' AND (species='balachowskyi' OR species='balachowskyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurysternus' AND (species='balachowskyi' OR species='balachowskyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='balachowskyi' OR junior_species='balachowskyii')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='Eurysternus' AND (species='balachowskyi' OR species='balachowskyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='cambeforti' OR junior_species='cambefortii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurysternus' AND (species='cambeforti' OR species='cambefortii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurysternus' AND (species='cambeforti' OR species='cambefortii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='cambeforti' OR junior_species='cambefortii')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='Eurysternus' AND (species='cambeforti' OR species='cambefortii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='caribaeus' OR junior_species='caribaeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurysternus' AND (species='caribaeus' OR species='caribaeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurysternus' AND (species='caribaeus' OR species='caribaeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='caribaeus' OR junior_species='caribaeus')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='Eurysternus' AND (species='caribaeus' OR species='caribaeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='cayennensis' OR junior_species='cayennensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurysternus' AND (species='cayennensis' OR species='cayennensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurysternus' AND (species='cayennensis' OR species='cayennensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='cayennensis' OR junior_species='cayennensis')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='Eurysternus' AND (species='cayennensis' OR species='cayennensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='cyclops' OR junior_species='cyclops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurysternus' AND (species='cyclops' OR species='cyclops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurysternus' AND (species='cyclops' OR species='cyclops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='cyclops' OR junior_species='cyclops')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='Eurysternus' AND (species='cyclops' OR species='cyclops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='vastiorum' OR junior_species='vastiorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurysternus' AND (species='vastiorum' OR species='vastiorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurysternus' AND (species='vastiorum' OR species='vastiorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='vastiorum' OR junior_species='vastiorum')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='Eurysternus' AND (species='vastiorum' OR species='vastiorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='hypocrita' OR junior_species='hypocrita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurysternus' AND (species='hypocrita' OR species='hypocrita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurysternus' AND (species='hypocrita' OR species='hypocrita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='hypocrita' OR junior_species='hypocrita')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='Eurysternus' AND (species='hypocrita' OR species='hypocrita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='ventricosus' OR junior_species='ventricosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurysternus' AND (species='ventricosus' OR species='ventricosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurysternus' AND (species='ventricosus' OR species='ventricosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='ventricosus' OR junior_species='ventricosus')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='Eurysternus' AND (species='ventricosus' OR species='ventricosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaphyrocanthon' AND (junior_species='quadriguttatus' OR junior_species='quadriguttatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glaphyrocanthon' AND (species='quadriguttatus' OR species='quadriguttatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glaphyrocanthon' AND (species='quadriguttatus' OR species='quadriguttatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaphyrocanthon' AND (junior_species='quadriguttatus' OR junior_species='quadriguttatus')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='Glaphyrocanthon' AND (species='quadriguttatus' OR species='quadriguttatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hansreia' AND (junior_species='affinis' OR junior_species='affinis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hansreia' AND (species='affinis' OR species='affinis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hansreia' AND (species='affinis' OR species='affinis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hansreia' AND (junior_species='affinis' OR junior_species='affinis')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='Hansreia' AND (species='affinis' OR species='affinis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='haematopus' OR junior_species='haematopus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='haematopus' OR species='haematopus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='haematopus' OR species='haematopus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='haematopus' OR junior_species='haematopus')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='Onthophagus' AND (species='haematopus' OR species='haematopus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' 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='Onthophagus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' 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='Onthophagus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxysternon' AND (junior_species='durantoni' OR junior_species='durantonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxysternon' AND (species='durantoni' OR species='durantonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxysternon' AND (species='durantoni' OR species='durantonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxysternon' AND (junior_species='durantoni' OR junior_species='durantonii')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='Oxysternon' AND (species='durantoni' OR species='durantonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxysternon' AND (junior_species='festivum' OR junior_species='festivum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxysternon' AND (species='festivum' OR species='festivum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxysternon' AND (species='festivum' OR species='festivum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxysternon' AND (junior_species='festivum' OR junior_species='festivum')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='Oxysternon' AND (species='festivum' OR species='festivum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scybalocanthon' AND (junior_species='pygidialis' OR junior_species='pygidialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scybalocanthon' AND (species='pygidialis' OR species='pygidialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scybalocanthon' AND (species='pygidialis' OR species='pygidialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scybalocanthon' AND (junior_species='pygidialis' OR junior_species='pygidialis')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='Scybalocanthon' AND (species='pygidialis' OR species='pygidialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvicanthon' 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='Sylvicanthon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sylvicanthon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvicanthon' 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='Sylvicanthon' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='sordidus' OR junior_species='sordidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthon' AND (species='sordidus' OR species='sordidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='sordidus' OR species='sordidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='sordidus' OR junior_species='sordidus')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='Canthon' AND (species='sordidus' OR species='sordidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroxys' 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='Uroxys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uroxys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroxys' 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='Uroxys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroxys' 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='Uroxys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uroxys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroxys' 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='Uroxys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroxys' 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='Uroxys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uroxys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroxys' 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='Uroxys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1664 The Ecological Register: Amazone Nature Lodge (February 2009)
Amazone Nature Lodge (February 2009)
Basic information
Sample name: Amazone Nature Lodge (February 2009)

Sample aka: Montagne de Kaw

Reference: F. Feer and O. Boissier. 2015. Variations in dung beetle assemblages across a gradient of hunting in a tropical forest. Ecological Indicators 57:164-170 [ER 1141]
Geography
Country: French Guiana


Coordinate: 4° 33' N, 52° 12' W
Coordinate basis: stated in text

Geography comments: a ridge with elevation up to 309 m and "The sampling site is on the upper slope"

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

WMT: 32.5

CMT: 22.4

MAP: 4099.0

Habitat comments: the habitat is "20–35 m high forest with closed canopy and open understorey"
CMT and WMT are for Rochambeau and are from Roger et al. (2013, Am J Trop Med Hyg)

Methods
Life forms: scarab beetles

Sampling methods: baited,pitfall traps

Sample size: 764 individuals

Years: 2007

Days: 4

Nets or traps: 12

Net or trap nights: 48

Sampling comments: pitfall traps "were baited with c. 40 g of fresh human faeces... Twelve traps (ten in Nouragues) were placed at each site, separated by 40–50 m along a linear transect... Traps were operated for 2 × 48 h periods"

Metadata
Sample number: 1664

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-07-01 19:47:58

Modified: 2016-01-17 05:58:45

Abundance distribution
43 species
9 singletons
total count 764
extrapolated richness: 64.5
Fisher's α: 9.855
geometric series k: 0.8895
Hurlbert's PIE: 0.9149
Shannon's H: 2.9403
Good's u: 0.9882
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Ateuchus murrayi10
Ateuchus simplex19
Ateuchus sp. 416
Ateuchus sp. 23
Ateuchus aff. substriatus2
Canthidium aterrimum1
Canthidium centrale16
Canthidium gerstaeckeri1
Canthidium aff. ruficolle1
Canthon vulcanoae2
Canthon 'bicolor'14
Canthon triangularis1
Deltochilum carinatum6
Deltochilum aff. guyanense9
Deltochilum icarus2
Deltochilum orbiculare1
Deltochilum septemstriatum1
Deltochilum submetallicum36
Deltochilum apicalis43
Deltochilum boreus5
Deltochilum robustus1
Deltochilum sp. 21
Deltochilum subaeneus32
Eurysternus balachowskyi1
Eurysternus cambeforti15
Eurysternus caribaeus10
Eurysternus cayennensis39
Eurysternus cyclops15
Eurysternus vastiorum2
Eurysternus hypocrita26
Eurysternus ventricosus3
Glaphyrocanthon quadriguttatus20
Hansreia cf. affinis124
Onthophagus haematopus14
Onthophagus sp. 29
Oxysternon durantoni7
Oxysternon festivum8
Scybalocanthon pygidialis20
Sylvicanthon sp.77
Canthon sordidus137
Uroxys sp. 12
Uroxys sp. 28
Uroxys sp. 34