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=633 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=633SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=320SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=633 ORDER BY register_no ASCSELECT 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='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='humerale' OR junior_species='humerale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthidium' AND (species='humerale' OR species='humerale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthidium' AND (species='humerale' OR species='humerale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthidium' AND (junior_species='humerale' OR junior_species='humerale')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='humerale' OR species='humerale') 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='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='Trichillum' AND (junior_species='externepunctatum' OR junior_species='externepunctatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichillum' AND (species='externepunctatum' OR species='externepunctatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichillum' AND (species='externepunctatum' OR species='externepunctatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichillum' AND (junior_species='externepunctatum' OR junior_species='externepunctatum')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='Trichillum' AND (species='externepunctatum' OR species='externepunctatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='chalybaeus' OR junior_species='chalybaeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthon' AND (species='chalybaeus' OR species='chalybaeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='chalybaeus' OR species='chalybaeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='chalybaeus' OR junior_species='chalybaeus')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='chalybaeus' OR species='chalybaeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='juvencus' OR junior_species='juvencus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthon' AND (species='juvencus' OR species='juvencus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='juvencus' OR species='juvencus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='juvencus' OR junior_species='juvencus')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='juvencus' OR species='juvencus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='lituratus' OR junior_species='lituratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthon' AND (species='lituratus' OR species='lituratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='lituratus' OR species='lituratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='lituratus' OR junior_species='lituratus')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='lituratus' OR species='lituratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='maldonadoi' OR junior_species='maldonadoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthon' AND (species='maldonadoi' OR species='maldonadoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='maldonadoi' OR species='maldonadoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='maldonadoi' OR junior_species='maldonadoii')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='maldonadoi' OR species='maldonadoii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='mutabilis' OR junior_species='mutabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthon' AND (species='mutabilis' OR species='mutabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='mutabilis' OR species='mutabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='mutabilis' OR junior_species='mutabilis')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='mutabilis' OR species='mutabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='nigripennis' OR junior_species='nigripennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthon' AND (species='nigripennis' OR species='nigripennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='nigripennis' OR species='nigripennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='nigripennis' OR junior_species='nigripennis')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='nigripennis' OR species='nigripennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='septemmaculatus' OR junior_species='septemmaculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthon' AND (species='septemmaculatus' OR species='septemmaculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='septemmaculatus' OR species='septemmaculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='septemmaculatus' OR junior_species='septemmaculatus')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='septemmaculatus' OR species='septemmaculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' 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='Canthon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' 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='Canthon' 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='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='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='Pseudocanthon' AND (junior_species='xanthurus' OR junior_species='xanthurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudocanthon' AND (species='xanthurus' OR species='xanthurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudocanthon' AND (species='xanthurus' OR species='xanthurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudocanthon' AND (junior_species='xanthurus' OR junior_species='xanthurus')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='Pseudocanthon' AND (species='xanthurus' OR species='xanthurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' AND (junior_species='bos' OR junior_species='bos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichotomius' AND (species='bos' OR species='bos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichotomius' AND (species='bos' OR species='bos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' AND (junior_species='bos' OR junior_species='bos')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='bos' OR species='bos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' AND (junior_species='geminatus' OR junior_species='geminatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichotomius' AND (species='geminatus' OR species='geminatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichotomius' AND (species='geminatus' OR species='geminatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' AND (junior_species='geminatus' OR junior_species='geminatus')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='geminatus' OR species='geminatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' AND (junior_species='nisus' OR junior_species='nisus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichotomius' AND (species='nisus' OR species='nisus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichotomius' AND (species='nisus' OR species='nisus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' AND (junior_species='nisus' OR junior_species='nisus')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='nisus' OR species='nisus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' AND (junior_species='semisquamosus' OR junior_species='semisquamosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichotomius' AND (species='semisquamosus' OR species='semisquamosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichotomius' AND (species='semisquamosus' OR species='semisquamosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' AND (junior_species='semisquamosus' OR junior_species='semisquamosus')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='semisquamosus' OR species='semisquamosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' AND (junior_species='sericeus' OR junior_species='sericeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichotomius' AND (species='sericeus' OR species='sericeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichotomius' AND (species='sericeus' OR species='sericeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichotomius' AND (junior_species='sericeus' OR junior_species='sericeus')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='sericeus' OR species='sericeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ontherus' AND (junior_species='azteca' OR junior_species='azteca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ontherus' AND (species='azteca' OR species='azteca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ontherus' AND (species='azteca' OR species='azteca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ontherus' AND (junior_species='azteca' OR junior_species='azteca')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='Ontherus' AND (species='azteca' OR species='azteca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='hirtellus' OR junior_species='hirtellus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurysternus' AND (species='hirtellus' OR species='hirtellus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurysternus' AND (species='hirtellus' OR species='hirtellus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurysternus' AND (junior_species='hirtellus' OR junior_species='hirtellus')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='hirtellus' OR species='hirtellus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Digitonthophagus' AND (junior_species='gazella' OR junior_species='gazella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Digitonthophagus' AND (species='gazella' OR species='gazella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Digitonthophagus' AND (species='gazella' OR species='gazella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Digitonthophagus' AND (junior_species='gazella' OR junior_species='gazella')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='Digitonthophagus' AND (species='gazella' OR species='gazella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='bidentatus' OR junior_species='bidentatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='bidentatus' OR species='bidentatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='bidentatus' OR species='bidentatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='bidentatus' OR junior_species='bidentatus')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='bidentatus' OR species='bidentatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='hirculus' OR junior_species='hirculus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='hirculus' OR species='hirculus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='hirculus' OR species='hirculus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='hirculus' OR junior_species='hirculus')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='hirculus' OR species='hirculus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coprophanaeus' AND (junior_species='cyanescens' OR junior_species='cyanescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coprophanaeus' AND (species='cyanescens' OR species='cyanescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coprophanaeus' AND (species='cyanescens' OR species='cyanescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coprophanaeus' AND (junior_species='cyanescens' OR junior_species='cyanescens')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='cyanescens' OR species='cyanescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coprophanaeus' AND (junior_species='pertyi' OR junior_species='pertyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coprophanaeus' AND (species='pertyi' OR species='pertyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coprophanaeus' AND (species='pertyi' OR species='pertyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coprophanaeus' AND (junior_species='pertyi' OR junior_species='pertyii')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='pertyi' OR species='pertyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diabroctis' AND (junior_species='mimas' OR junior_species='mimas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diabroctis' AND (species='mimas' OR species='mimas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diabroctis' AND (species='mimas' OR species='mimas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diabroctis' AND (junior_species='mimas' OR junior_species='mimas')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='Diabroctis' AND (species='mimas' OR species='mimas') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=633 The Ecological Register: Charles Darwin Ecological Refuge (open habitat)
Charles Darwin Ecological Refuge (open habitat)
Basic information
Sample name: Charles Darwin Ecological Refuge (open habitat)

Reference: F. A. B. Silva, C. M. Q. Costa, R. C. Moura, and A. I. Farias. 2010. Study of the dung beetle (Coleoptera: Scarabaeidae) community at two sites: Atlantic forest and clear-cut, Pernambuco, Brazil. Environmental Entomology 39(2):359-367 [ER 320]
Geography
Country: Brazil

State: Pernambuco


Coordinate: -7.83° S, -34.74° W
Coordinate basis: estimated from map

Geography comments: "in the municipality of Igarassu"
coordinate stated in the text is 7° 48' 37" S, 34° 27' 25" W, which is certainly wrong
correct coordinate is shown by Google Maps

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: pasture

Substrate: ground surface

MAT: 25.0

MAP: 2000.0

Habitat comments: "Atlantic rainforest" and specifically in "an open area that had been converted into pasture for cattle before the implementation of the conservation unit"

Methods
Life forms: scarab beetles

Sites: 6

Site area: 0.96

Sampling methods: quadrat,baited,pitfall traps

Sample size: 874 individuals

Years: 2006

Days: 24

Nets or traps: 24

Net or trap nights: 576

Sampling comments: 24 pitfall traps "baited with human dung and bovine carrion" and "distributed over four points that formed a square" with points "40 m apart" (i.e., six 40 x 40 m quadrats) that were operated for 48 hours once a month over 12 months

Metadata
Sample number: 633

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-28 14:57:25

Modified: 2021-07-11 05:24:40

Abundance distribution
33 species
6 singletons
total count 874
extrapolated richness: 46.5
Fisher's α: 6.781
geometric series k: 0.8504
Hurlbert's PIE: 0.8965
Shannon's H: 2.6487
Good's u: 0.9931
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Ateuchus sp. 21
Ateuchus sp. 31
Ateuchus sp. 410
Canthidium humerale6
Canthidium sp. 16
Canthidium sp. 224
Canthidium sp. 37
Canthidium sp. 41
Trichillum externepunctatum5
Canthon chalybaeus19
Canthon aff. juvencus2
Canthon lituratus48
Canthon aff. maldonadoi1
Canthon mutabilis112
Canthon nigripennis3
Canthon septemmaculatus histrio4
Canthon (Glaphyrocanthon) sp. 144
Deltochilum (Deltohyboma) sp. 1104
Deltochilum (Deltohyboma) sp. 24
Pseudocanthon xanthurus6
Dichotomius bos35
Dichotomius geminatus179
Dichotomius nisus11
Dichotomius semisquamosus23
Dichotomius aff. sericeus29
Ontherus azteca1
Eurysternus aff. hirtellus28
Digitonthophagus gazella7
Onthophagus aff. bidentatus5
Onthophagus aff. hirculus117
Coprophanaeus cyanescens28
Coprophanaeus pertyi1
Diabroctis mimas2