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=649 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=649SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=330SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=649 ORDER BY register_no ASCSELECT 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='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='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='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='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='Canthidium' AND (species='guyanense' OR species='guyanense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthidium' AND (species='guyanense' OR species='guyanense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' 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='Canthidium' AND (species='guyanense' OR species='guyanense') 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='Canthidium' 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='Canthidium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthidium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' 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='Canthidium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' 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='Canthidium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthidium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' 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='Canthidium' 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='Dichotomius' AND (junior_species='lucasi' OR junior_species='lucasii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichotomius' AND (species='lucasi' OR species='lucasii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichotomius' AND (species='lucasi' OR species='lucasii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' AND (junior_species='lucasi' OR junior_species='lucasii')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='Dichotomius' AND (species='lucasi' OR species='lucasii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' 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='Dichotomius' AND (species='apicalis' OR species='apicalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichotomius' AND (species='apicalis' OR species='apicalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' 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='Dichotomius' AND (species='apicalis' OR species='apicalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' 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='Dichotomius' AND (species='subaeneus' OR species='subaeneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichotomius' AND (species='subaeneus' OR species='subaeneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' 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='Dichotomius' AND (species='subaeneus' OR species='subaeneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' 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='Dichotomius' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichotomius' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' 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='Dichotomius' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' 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='Dichotomius' AND (species='boreus' OR species='boreus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichotomius' AND (species='boreus' OR species='boreus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' 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='Dichotomius' AND (species='boreus' OR species='boreus') 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='rubrescens' OR junior_species='rubrescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='rubrescens' OR species='rubrescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='rubrescens' OR species='rubrescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='rubrescens' OR junior_species='rubrescens')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='rubrescens' OR species='rubrescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='xanthomerus' OR junior_species='xanthomerus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='xanthomerus' OR species='xanthomerus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='xanthomerus' OR species='xanthomerus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='xanthomerus' OR junior_species='xanthomerus')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='xanthomerus' OR species='xanthomerus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coprophanaeus' AND (junior_species='parvulus' OR junior_species='parvulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coprophanaeus' AND (species='parvulus' OR species='parvulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coprophanaeus' AND (species='parvulus' OR species='parvulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coprophanaeus' AND (junior_species='parvulus' OR junior_species='parvulus')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='parvulus' OR species='parvulus') 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='Coprophanaeus' AND (junior_species='jasius' OR junior_species='jasius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coprophanaeus' AND (species='jasius' OR species='jasius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coprophanaeus' AND (species='jasius' OR species='jasius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coprophanaeus' AND (junior_species='jasius' OR junior_species='jasius')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='jasius' OR species='jasius') 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='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='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='Trichocanthon' 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='Trichocanthon' AND (species='sordidus' OR species='sordidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichocanthon' AND (species='sordidus' OR species='sordidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichocanthon' 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='Trichocanthon' AND (species='sordidus' OR species='sordidus') 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='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='candezei' OR junior_species='candezeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvicanthon' AND (species='candezei' OR species='candezeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sylvicanthon' AND (species='candezei' OR species='candezeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvicanthon' AND (junior_species='candezei' OR junior_species='candezeii')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='candezei' OR species='candezeii') 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='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='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='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='Eurysternus' AND (junior_species='confusus' OR junior_species='confusus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurysternus' AND (species='confusus' OR species='confusus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurysternus' AND (species='confusus' OR species='confusus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='confusus' OR junior_species='confusus')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='confusus' OR species='confusus') 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='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='Aphodius' 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='Aphodius' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' 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='Aphodius' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=649 The Ecological Register: Nouragues Biological Field Station (hour 21)
Nouragues Biological Field Station (hour 21)
Basic information
Sample name: Nouragues Biological Field Station (hour 21)

Reference: F. Feer and S. Pincebourde. 2005. Diel flight activity and ecological segregation within an assemblage of tropical forest dung and carrion beetles. Journal of Tropical Ecology 21:21-30 [ER 330]
Geography
Country: French Guiana


Coordinate: 4° 5' N, 52° 40' W
Coordinate basis: stated in text

Geography comments: "100 km south of Cayenne"

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAT: 26.3

MAP: 2990.0

Habitat comments: "undisturbed evergreen forest"

Methods
Life forms: scarab beetles

Site length: 180

Sampling methods: line transect,baited,pitfall traps

Sample size: 1051 individuals

Years: 1995 - 2002

Days: 16

Nets or traps: 10

Net or trap nights: 160

Sampling comments: 10 baited pitfall traps "spaced 20 m apart along a linear transect" variously baited with human or howler monkey dung or with carrion; "Each study was carried out over a 24-h period with faeces and a 48-h period with carrion... We ran the trapping programme with 40% carrion (n = 150 trap days), 30% human faeces and 30% howler dung in February, April, May and October between 1995 and 2002" (i.e., 10 traps x 3 days x 4 months x 8 years), but each sample corresponds to a 4 hour sampling period out of a 24 hour day, so the total number of sampling days is 96/6

Metadata
Sample number: 649

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-29 21:40:59

Modified: 2015-09-30 04:29:56

Abundance distribution
38 species
6 singletons
total count 1051
extrapolated richness: 58.4
Fisher's α: 7.723
geometric series k: 0.8453
Hurlbert's PIE: 0.7434
Shannon's H: 2.0942
Good's u: 0.9943
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Ateuchus simplex501
Ateuchus murrayi99
Ateuchus sp. 22
Canthidium aterrimum20
Canthidium aff. guyanense3
Canthidium deyrollei4
Canthidium dohrni2
Canthidium sp. 14
Canthidium sp. 24
Uroxys sp. 221
Dichotomius lucasi96
Dichotomius apicalis2
Dichotomius subaeneus1
Dichotomius sp. 13
Dichotomius boreus14
Onthophagus haematopus12
Onthophagus rubrescens21
Onthophagus xanthomerus3
Coprophanaeus parvulus2
Coprophanaeus dardanus2
Coprophanaeus jasius2
Coprophanaeus (Megaphanaeus) lancifer4
Oxysternon durantoni12
Oxysternon festivum1
Canthon 'bicolor'17
Trichocanthon sordidus2
Hansreia affinis2
Scybalocanthon pygidialis1
Sylvicanthon candezei1
Deltochilum septemstriatum86
Deltochilum guyanense9
Deltochilum submetallicum47
Deltochilum carinatum6
Deltochilum icarus1
Eurysternus confusus4
Eurysternus cayennensis1
Eurysternus caribaeus5
Aphodius sp. 134