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=1271 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1271SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=318SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1271 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scarabaeus' AND (junior_species='galenus' OR junior_species='galenus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scarabaeus' AND (species='galenus' OR species='galenus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scarabaeus' AND (species='galenus' OR species='galenus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scarabaeus' AND (junior_species='galenus' OR junior_species='galenus')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='Scarabaeus' AND (species='galenus' OR species='galenus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neosisyphus' AND (junior_species='mirabilis' OR junior_species='mirabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neosisyphus' AND (species='mirabilis' OR species='mirabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neosisyphus' AND (species='mirabilis' OR species='mirabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neosisyphus' AND (junior_species='mirabilis' OR junior_species='mirabilis')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='Neosisyphus' AND (species='mirabilis' OR species='mirabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaria' 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='Pedaria' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedaria' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaria' 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='Pedaria' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharsius' AND (junior_species='harpagus' OR junior_species='harpagus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catharsius' AND (species='harpagus' OR species='harpagus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catharsius' AND (species='harpagus' OR species='harpagus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharsius' AND (junior_species='harpagus' OR junior_species='harpagus')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='Catharsius' AND (species='harpagus' OR species='harpagus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharsius' AND (junior_species='mossambicanus' OR junior_species='mossambicanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catharsius' AND (species='mossambicanus' OR species='mossambicanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catharsius' AND (species='mossambicanus' OR species='mossambicanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharsius' AND (junior_species='mossambicanus' OR junior_species='mossambicanus')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='Catharsius' AND (species='mossambicanus' OR species='mossambicanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copris' AND (junior_species='inhalatus' OR junior_species='inhalatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Copris' AND (species='inhalatus' OR species='inhalatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Copris' AND (species='inhalatus' OR species='inhalatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copris' AND (junior_species='inhalatus' OR junior_species='inhalatus')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='Copris' AND (species='inhalatus' OR species='inhalatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metacatharsius' AND (junior_species='zuluanus' OR junior_species='zuluanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metacatharsius' AND (species='zuluanus' OR species='zuluanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metacatharsius' AND (species='zuluanus' OR species='zuluanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metacatharsius' AND (junior_species='zuluanus' OR junior_species='zuluanus')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='Metacatharsius' AND (species='zuluanus' OR species='zuluanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caccobius' 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='Caccobius' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caccobius' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caccobius' 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='Caccobius' 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='fimetarius' OR junior_species='fimetarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='fimetarius' OR species='fimetarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='fimetarius' OR species='fimetarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='fimetarius' OR junior_species='fimetarius')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='fimetarius' OR species='fimetarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='vinctus' OR junior_species='vinctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='vinctus' OR species='vinctus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='vinctus' OR species='vinctus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='vinctus' OR junior_species='vinctus')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='vinctus' OR species='vinctus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scarabaeus' AND (junior_species='clanceyi' OR junior_species='clanceyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scarabaeus' AND (species='clanceyi' OR species='clanceyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scarabaeus' AND (species='clanceyi' OR species='clanceyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scarabaeus' AND (junior_species='clanceyi' OR junior_species='clanceyii')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='Scarabaeus' AND (species='clanceyi' OR species='clanceyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scarabaeus' AND (junior_species='xavieri' OR junior_species='xavierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scarabaeus' AND (species='xavieri' OR species='xavierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scarabaeus' AND (species='xavieri' OR species='xavierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scarabaeus' AND (junior_species='xavieri' OR junior_species='xavierii')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='Scarabaeus' AND (species='xavieri' OR species='xavierii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' 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='Sisyphus' AND (species='sordidus' OR species='sordidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sisyphus' AND (species='sordidus' OR species='sordidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' 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='Sisyphus' AND (species='sordidus' OR species='sordidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copris' AND (junior_species='puncticollis' OR junior_species='puncticollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Copris' AND (species='puncticollis' OR species='puncticollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Copris' AND (species='puncticollis' OR species='puncticollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copris' AND (junior_species='puncticollis' OR junior_species='puncticollis')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='Copris' AND (species='puncticollis' OR species='puncticollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimonthophagus' AND (junior_species='ambiguus' OR junior_species='ambiguus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mimonthophagus' AND (species='ambiguus' OR species='ambiguus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mimonthophagus' AND (species='ambiguus' OR species='ambiguus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimonthophagus' AND (junior_species='ambiguus' OR junior_species='ambiguus')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='Mimonthophagus' AND (species='ambiguus' OR species='ambiguus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proagoderus' AND (junior_species='aciculatus' OR junior_species='aciculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Proagoderus' AND (species='aciculatus' OR species='aciculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Proagoderus' AND (species='aciculatus' OR species='aciculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proagoderus' AND (junior_species='aciculatus' OR junior_species='aciculatus')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='Proagoderus' AND (species='aciculatus' OR species='aciculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proagoderus' AND (junior_species='aureiceps' OR junior_species='aureiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Proagoderus' AND (species='aureiceps' OR species='aureiceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Proagoderus' AND (species='aureiceps' OR species='aureiceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proagoderus' AND (junior_species='aureiceps' OR junior_species='aureiceps')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='Proagoderus' AND (species='aureiceps' OR species='aureiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anachalcos' AND (junior_species='convexus' OR junior_species='convexus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anachalcos' AND (species='convexus' OR species='convexus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anachalcos' AND (species='convexus' OR species='convexus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anachalcos' AND (junior_species='convexus' OR junior_species='convexus')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='Anachalcos' AND (species='convexus' OR species='convexus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachylomera' AND (junior_species='femoralis' OR junior_species='femoralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachylomera' AND (species='femoralis' OR species='femoralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachylomera' AND (species='femoralis' OR species='femoralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachylomera' AND (junior_species='femoralis' OR junior_species='femoralis')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='Pachylomera' AND (species='femoralis' OR species='femoralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scarabaeus' AND (junior_species='lamarck' OR junior_species='lamarck')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scarabaeus' AND (species='lamarck' OR species='lamarck') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scarabaeus' AND (species='lamarck' OR species='lamarck')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scarabaeus' AND (junior_species='lamarck' OR junior_species='lamarck')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='Scarabaeus' AND (species='lamarck' OR species='lamarck') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allogymnopleurus' AND (junior_species='thalassinus' OR junior_species='thalassinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allogymnopleurus' AND (species='thalassinus' OR species='thalassinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allogymnopleurus' AND (species='thalassinus' OR species='thalassinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allogymnopleurus' AND (junior_species='thalassinus' OR junior_species='thalassinus')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='Allogymnopleurus' AND (species='thalassinus' OR species='thalassinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnopleurus' AND (junior_species='virens' OR junior_species='virens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gymnopleurus' AND (species='virens' OR species='virens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnopleurus' AND (species='virens' OR species='virens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnopleurus' AND (junior_species='virens' OR junior_species='virens')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='Gymnopleurus' AND (species='virens' OR species='virens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neosisyphus' AND (junior_species='confrater' OR junior_species='confrater')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neosisyphus' AND (species='confrater' OR species='confrater') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neosisyphus' AND (species='confrater' OR species='confrater')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neosisyphus' AND (junior_species='confrater' OR junior_species='confrater')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='Neosisyphus' AND (species='confrater' OR species='confrater') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neosisyphus' AND (junior_species='fortuitus' OR junior_species='fortuitus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neosisyphus' AND (species='fortuitus' OR species='fortuitus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neosisyphus' AND (species='fortuitus' OR species='fortuitus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neosisyphus' AND (junior_species='fortuitus' OR junior_species='fortuitus')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='Neosisyphus' AND (species='fortuitus' OR species='fortuitus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neosisyphus' AND (junior_species='spinipes' OR junior_species='spinipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neosisyphus' AND (species='spinipes' OR species='spinipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neosisyphus' AND (species='spinipes' OR species='spinipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neosisyphus' AND (junior_species='spinipes' OR junior_species='spinipes')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='Neosisyphus' AND (species='spinipes' OR species='spinipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharsius' AND (junior_species='tricornutus' OR junior_species='tricornutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catharsius' AND (species='tricornutus' OR species='tricornutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catharsius' AND (species='tricornutus' OR species='tricornutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharsius' AND (junior_species='tricornutus' OR junior_species='tricornutus')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='Catharsius' AND (species='tricornutus' OR species='tricornutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metacatharsius' AND (junior_species='opacus' OR junior_species='opacus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metacatharsius' AND (species='opacus' OR species='opacus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metacatharsius' AND (species='opacus' OR species='opacus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metacatharsius' AND (junior_species='opacus' OR junior_species='opacus')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='Metacatharsius' AND (species='opacus' OR species='opacus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metacatharsius' AND (junior_species='troglodytes' OR junior_species='troglodytes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metacatharsius' AND (species='troglodytes' OR species='troglodytes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metacatharsius' AND (species='troglodytes' OR species='troglodytes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metacatharsius' AND (junior_species='troglodytes' OR junior_species='troglodytes')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='Metacatharsius' AND (species='troglodytes' OR species='troglodytes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onitis' AND (junior_species='deceptor' OR junior_species='deceptor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onitis' AND (species='deceptor' OR species='deceptor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onitis' AND (species='deceptor' OR species='deceptor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onitis' AND (junior_species='deceptor' OR junior_species='deceptor')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='Onitis' AND (species='deceptor' OR species='deceptor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caccobius' AND (junior_species='cavatus' OR junior_species='cavatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caccobius' AND (species='cavatus' OR species='cavatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caccobius' AND (species='cavatus' OR species='cavatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caccobius' AND (junior_species='cavatus' OR junior_species='cavatus')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='Caccobius' AND (species='cavatus' OR species='cavatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caccobius' AND (junior_species='nigritulus' OR junior_species='nigritulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caccobius' AND (species='nigritulus' OR species='nigritulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caccobius' AND (species='nigritulus' OR species='nigritulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caccobius' AND (junior_species='nigritulus' OR junior_species='nigritulus')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='Caccobius' AND (species='nigritulus' OR species='nigritulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cleptocaccobius' AND (junior_species='viridicollis' OR junior_species='viridicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cleptocaccobius' AND (species='viridicollis' OR species='viridicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cleptocaccobius' AND (species='viridicollis' OR species='viridicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cleptocaccobius' AND (junior_species='viridicollis' OR junior_species='viridicollis')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='Cleptocaccobius' AND (species='viridicollis' OR species='viridicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyalonthophagus' AND (junior_species='alcyonides' OR junior_species='alcyonides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyalonthophagus' AND (species='alcyonides' OR species='alcyonides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyalonthophagus' AND (species='alcyonides' OR species='alcyonides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyalonthophagus' AND (junior_species='alcyonides' OR junior_species='alcyonides')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='Hyalonthophagus' AND (species='alcyonides' OR species='alcyonides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='aeruginosus' OR junior_species='aeruginosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='aeruginosus' OR species='aeruginosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='aeruginosus' OR species='aeruginosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='aeruginosus' OR junior_species='aeruginosus')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='aeruginosus' OR species='aeruginosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='flavolimbatus' OR junior_species='flavolimbatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='flavolimbatus' OR species='flavolimbatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='flavolimbatus' OR species='flavolimbatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='flavolimbatus' OR junior_species='flavolimbatus')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='flavolimbatus' OR species='flavolimbatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='obtusicornis' OR junior_species='obtusicornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='obtusicornis' OR species='obtusicornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='obtusicornis' OR species='obtusicornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='obtusicornis' OR junior_species='obtusicornis')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='obtusicornis' OR species='obtusicornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='pullus' OR junior_species='pullus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='pullus' OR species='pullus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='pullus' OR species='pullus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='pullus' OR junior_species='pullus')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='pullus' OR species='pullus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='signatus' OR junior_species='signatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='signatus' OR species='signatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='signatus' OR species='signatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='signatus' OR junior_species='signatus')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='signatus' OR species='signatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='stellio' OR junior_species='stellio')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='stellio' OR species='stellio') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='stellio' OR species='stellio')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='stellio' OR junior_species='stellio')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='stellio' OR species='stellio') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euoniticellus' AND (junior_species='triangulatus' OR junior_species='triangulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euoniticellus' AND (species='triangulatus' OR species='triangulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euoniticellus' AND (species='triangulatus' OR species='triangulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euoniticellus' AND (junior_species='triangulatus' OR junior_species='triangulatus')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='Euoniticellus' AND (species='triangulatus' OR species='triangulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oniticellus' AND (junior_species='planatus' OR junior_species='planatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oniticellus' AND (species='planatus' OR species='planatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oniticellus' AND (species='planatus' OR species='planatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oniticellus' AND (junior_species='planatus' OR junior_species='planatus')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='Oniticellus' AND (species='planatus' OR species='planatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caccobius' 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='Caccobius' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caccobius' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caccobius' 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='Caccobius' 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 * FROM register WHERE sample_no=1271 The Ecological Register: Maputo Special Reserve (reserve farm)
Maputo Special Reserve (reserve farm)
Basic information
Sample name: Maputo Special Reserve (reserve farm)

Reference: C. T. Jacobs, C. H. Scholtz, F. Escobar, and A. L. V. Davis. 2010. How might intensification of farming influence dung beetle diversity (Coleoptera: Scarabaeidae) in Maputo Special Reserve (Mozambique)?. Journal of Insect Conservation 14(4):389-399 [ER 318]
Geography
Country: Mozambique


Coordinate: -26.5° S, 32.8° E
Coordinate basis: estimated from map

Geography comments: "50–70 km south of Maputo"
coordinate estimated from map in text
altitude 43 to 67 m

•
Environment
Habitat: tropical/subtropical savanna

Altered habitat: cropland

Substrate: ground surface

MAT: 22.3

MAP: 755.0

Habitat comments: precip 747 to 762 mm

Methods
Life forms: scarab beetles

Sites: 3

Sampling methods: baited,pitfall traps

Sample size: 8127 individuals

Years: 2007

Days: 2

Nets or traps: 15

Net or trap nights: 60

Sampling comments: five pig dung-baited pitfall traps placed "50 m apart" in each of three sites and "operated for 48 h" (apparently on one occasion)

Metadata
Sample number: 1271

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-18 11:16:01

Modified: 2015-10-02 21:48:13

Abundance distribution
43 species
5 singletons
total count 8127
extrapolated richness: 52.8
Fisher's α: 5.956
geometric series k: 0.8305
Hurlbert's PIE: 0.8352
Shannon's H: 2.3649
Good's u: 0.9994
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Scarabaeus galenus1
Neosisyphus mirabilis1
Pedaria sp. III187
Catharsius harpagus5
Catharsius mossambicanus17
Copris inhalatus santaluciae29
Metacatharsius zuluanus99
Caccobius sp. 3296
Onthophagus aff. fimetarius74
Onthophagus aff. vinctus37
Scarabaeus (Scarabaeolus) clanceyi109
Scarabaeus (Scarabaeolus) xavieri16
Sisyphus sordidus7
Copris puncticollis102
Mimonthophagus ambiguus378
Proagoderus aciculatus136
Proagoderus aureiceps1902
Anachalcos convexus129
Pachylomera femoralis776
Scarabaeus (Kheper) lamarck38
Allogymnopleurus thalassinus111
Gymnopleurus virens77
Neosisyphus confrater76
Neosisyphus fortuitus7
Neosisyphus spinipes23
Catharsius tricornutus3
Metacatharsius opacus30
Metacatharsius troglodytes8
Onitis deceptor5
Caccobius cavatus20
Caccobius nigritulus448
Cleptocaccobius viridicollis5
Hyalonthophagus ? alcyonides5
Onthophagus aeruginosus2
Onthophagus flavolimbatus1
Onthophagus obtusicornis189
Onthophagus aff. pullus79
Onthophagus signatus2448
Onthophagus stellio5
Euoniticellus triangulatus1
Oniticellus planatus1
Caccobius sp. 14
Onthophagus sp. 2240