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=1663 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1663SELECT 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=1663 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='Canthidium' AND (junior_species='deyrollei' OR junior_species='deyrolleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthidium' AND (species='deyrollei' OR species='deyrolleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthidium' AND (species='deyrollei' OR species='deyrolleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='deyrollei' OR junior_species='deyrolleii')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='deyrollei' OR species='deyrolleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='dohrni' OR junior_species='dohrnii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthidium' AND (species='dohrni' OR species='dohrnii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthidium' AND (species='dohrni' OR species='dohrnii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='dohrni' OR junior_species='dohrnii')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='dohrni' OR species='dohrnii') 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='Coprophanaeus' AND (junior_species='lancifer' OR junior_species='lancifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coprophanaeus' AND (species='lancifer' OR species='lancifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coprophanaeus' AND (species='lancifer' OR species='lancifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coprophanaeus' AND (junior_species='lancifer' OR junior_species='lancifer')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='Coprophanaeus' AND (species='lancifer' OR species='lancifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coprophanaeus' AND (junior_species='dardanus' OR junior_species='dardanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coprophanaeus' AND (species='dardanus' OR species='dardanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coprophanaeus' AND (species='dardanus' OR species='dardanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coprophanaeus' AND (junior_species='dardanus' OR junior_species='dardanus')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='Coprophanaeus' AND (species='dardanus' OR species='dardanus') 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='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='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='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='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='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='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='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='Phanaeus' AND (junior_species='chalcomelas' OR junior_species='chalcomelas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phanaeus' AND (species='chalcomelas' OR species='chalcomelas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phanaeus' AND (species='chalcomelas' OR species='chalcomelas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phanaeus' AND (junior_species='chalcomelas' OR junior_species='chalcomelas')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='Phanaeus' AND (species='chalcomelas' OR species='chalcomelas') 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 * FROM register WHERE sample_no=1663 The Ecological Register: Nouragues Research Station (November 2007)
Nouragues Research Station (November 2007)
Basic information
Sample name: Nouragues Research Station (November 2007)

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° 5' N, 52° 40' W
Coordinate basis: stated in text

Geography comments: elevation 60 to 200 m

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAT: 27.0

MAP: 2690.0

Habitat comments: "The climate is of equatorial type and is characterized by one dry (August–November) and one wet season (December–July)" and the habitat is "20–35 m high forest with closed canopy and open understorey"

Methods
Life forms: scarab beetles

Sampling methods: baited,pitfall traps

Sample size: 584 individuals

Years: 2007

Days: 4

Nets or traps: 10

Net or trap nights: 40

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: 1663

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-07-01 19:35:19

Modified: 2015-07-01 09:35:19

Abundance distribution
33 species
7 singletons
total count 584
extrapolated richness: 52.9
Fisher's α: 7.572
geometric series k: 0.8585
Hurlbert's PIE: 0.8726
Shannon's H: 2.5171
Good's u: 0.9880
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Ateuchus murrayi7
Ateuchus simplex3
Canthidium deyrollei1
Canthidium dohrni1
Canthon 'bicolor'132
Coprophanaeus (Megaphanaeus) lancifer1
Coprophanaeus dardanus2
Deltochilum carinatum1
Deltochilum icarus1
Deltochilum septemstriatum4
Deltochilum submetallicum2
Deltochilum boreus31
Deltochilum robustus3
Deltochilum subaeneus2
Eurysternus balachowskyi2
Eurysternus cambeforti1
Eurysternus caribaeus7
Eurysternus cayennensis2
Eurysternus vastiorum7
Eurysternus hypocrita2
Glaphyrocanthon quadriguttatus3
Hansreia cf. affinis129
Onthophagus haematopus56
Onthophagus sp. 246
Onthophagus sp. 15
Oxysternon durantoni24
Oxysternon festivum30
Phanaeus chalcomelas1
Scybalocanthon pygidialis20
Sylvicanthon sp.10
Canthon sordidus22
Uroxys sp. 218
Uroxys sp. 38