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=689 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=689SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=359SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=689 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hister' AND (junior_species='abbreviatus' OR junior_species='abbreviatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hister' AND (species='abbreviatus' OR species='abbreviatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hister' AND (species='abbreviatus' OR species='abbreviatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hister' AND (junior_species='abbreviatus' OR junior_species='abbreviatus')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='Hister' AND (species='abbreviatus' OR species='abbreviatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelister' AND (junior_species='subrotundus' OR junior_species='subrotundus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phelister' AND (species='subrotundus' OR species='subrotundus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phelister' AND (species='subrotundus' OR species='subrotundus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelister' AND (junior_species='subrotundus' OR junior_species='subrotundus')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='Phelister' AND (species='subrotundus' OR species='subrotundus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hister' AND (junior_species='americanus' OR junior_species='americanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hister' AND (species='americanus' OR species='americanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hister' AND (species='americanus' OR species='americanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hister' AND (junior_species='americanus' OR junior_species='americanus')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='Hister' AND (species='americanus' OR species='americanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphaeridium' AND (junior_species='lunatum' OR junior_species='lunatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphaeridium' AND (species='lunatum' OR species='lunatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphaeridium' AND (species='lunatum' OR species='lunatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphaeridium' AND (junior_species='lunatum' OR junior_species='lunatum')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='Sphaeridium' AND (species='lunatum' OR species='lunatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphaeridium' AND (junior_species='scarabaeoides' OR junior_species='scarabaeoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphaeridium' AND (species='scarabaeoides' OR species='scarabaeoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphaeridium' AND (species='scarabaeoides' OR species='scarabaeoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphaeridium' AND (junior_species='scarabaeoides' OR junior_species='scarabaeoides')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='Sphaeridium' AND (species='scarabaeoides' OR species='scarabaeoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphaeridium' AND (junior_species='bipustulatum' OR junior_species='bipustulatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphaeridium' AND (species='bipustulatum' OR species='bipustulatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphaeridium' AND (species='bipustulatum' OR species='bipustulatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphaeridium' AND (junior_species='bipustulatum' OR junior_species='bipustulatum')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='Sphaeridium' AND (species='bipustulatum' OR species='bipustulatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyon' AND (junior_species='pygmaeus' OR junior_species='pygmaeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercyon' AND (species='pygmaeus' OR species='pygmaeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercyon' AND (species='pygmaeus' OR species='pygmaeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyon' AND (junior_species='pygmaeus' OR junior_species='pygmaeus')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='Cercyon' AND (species='pygmaeus' OR species='pygmaeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyon' AND (junior_species='quisquilius' OR junior_species='quisquilius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercyon' AND (species='quisquilius' OR species='quisquilius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercyon' AND (species='quisquilius' OR species='quisquilius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyon' AND (junior_species='quisquilius' OR junior_species='quisquilius')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='Cercyon' AND (species='quisquilius' OR species='quisquilius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyon' AND (junior_species='lateralis' OR junior_species='lateralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercyon' AND (species='lateralis' OR species='lateralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercyon' AND (species='lateralis' OR species='lateralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyon' AND (junior_species='lateralis' OR junior_species='lateralis')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='Cercyon' AND (species='lateralis' OR species='lateralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyon' AND (junior_species='unipunctatus' OR junior_species='unipunctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercyon' AND (species='unipunctatus' OR species='unipunctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercyon' AND (species='unipunctatus' OR species='unipunctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyon' AND (junior_species='unipunctatus' OR junior_species='unipunctatus')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='Cercyon' AND (species='unipunctatus' OR species='unipunctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyon' AND (junior_species='praetestatus' OR junior_species='praetestatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercyon' AND (species='praetestatus' OR species='praetestatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercyon' AND (species='praetestatus' OR species='praetestatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyon' AND (junior_species='praetestatus' OR junior_species='praetestatus')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='Cercyon' AND (species='praetestatus' OR species='praetestatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptopleurum' AND (junior_species='minutum' OR junior_species='minutum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptopleurum' AND (species='minutum' OR species='minutum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptopleurum' AND (species='minutum' OR species='minutum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptopleurum' AND (junior_species='minutum' OR junior_species='minutum')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='Cryptopleurum' AND (species='minutum' OR species='minutum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='hecate' OR junior_species='hecate')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='hecate' OR species='hecate') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='hecate' OR species='hecate')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='hecate' OR junior_species='hecate')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='hecate' OR species='hecate') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='pennsylvanicus' OR junior_species='pennsylvanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='pennsylvanicus' OR species='pennsylvanicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='pennsylvanicus' OR species='pennsylvanicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='pennsylvanicus' OR junior_species='pennsylvanicus')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='pennsylvanicus' OR species='pennsylvanicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='haemorrhoidalis' OR junior_species='haemorrhoidalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='haemorrhoidalis' OR species='haemorrhoidalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='haemorrhoidalis' OR species='haemorrhoidalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='haemorrhoidalis' OR junior_species='haemorrhoidalis')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='haemorrhoidalis' OR species='haemorrhoidalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='granarius' OR junior_species='granarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='granarius' OR species='granarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='granarius' OR species='granarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='granarius' OR junior_species='granarius')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='granarius' OR species='granarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' 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='Aphodius' AND (species='fimetarius' OR species='fimetarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='fimetarius' OR species='fimetarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' 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='Aphodius' AND (species='fimetarius' OR species='fimetarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='vittatus' OR junior_species='vittatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='vittatus' OR species='vittatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='vittatus' OR species='vittatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='vittatus' OR junior_species='vittatus')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='vittatus' OR species='vittatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='distinctus' OR junior_species='distinctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='distinctus' OR species='distinctus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='distinctus' OR species='distinctus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='distinctus' OR junior_species='distinctus')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='distinctus' OR species='distinctus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='ruricola' OR junior_species='ruricola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='ruricola' OR species='ruricola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='ruricola' OR species='ruricola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='ruricola' OR junior_species='ruricola')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='ruricola' OR species='ruricola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='coloradensis' OR junior_species='coloradensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='coloradensis' OR species='coloradensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='coloradensis' OR species='coloradensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='coloradensis' OR junior_species='coloradensis')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='coloradensis' OR species='coloradensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='sterocorosa' OR junior_species='sterocorosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='sterocorosa' OR species='sterocorosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='sterocorosa' OR species='sterocorosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='sterocorosa' OR junior_species='sterocorosa')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='sterocorosa' OR species='sterocorosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='fossor' OR junior_species='fossor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='fossor' OR species='fossor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='fossor' OR species='fossor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='fossor' OR junior_species='fossor')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='fossor' OR species='fossor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='prodromus' OR junior_species='prodromus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='prodromus' OR species='prodromus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='prodromus' OR species='prodromus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='prodromus' OR junior_species='prodromus')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='prodromus' OR species='prodromus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copris' AND (junior_species='tullius' OR junior_species='tullius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Copris' AND (species='tullius' OR species='tullius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Copris' AND (species='tullius' OR species='tullius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copris' AND (junior_species='tullius' OR junior_species='tullius')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='tullius' OR species='tullius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ataenius' AND (junior_species='spretulus' OR junior_species='spretulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ataenius' AND (species='spretulus' OR species='spretulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ataenius' AND (species='spretulus' OR species='spretulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ataenius' AND (junior_species='spretulus' OR junior_species='spretulus')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='Ataenius' AND (species='spretulus' OR species='spretulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platystethus' AND (junior_species='americanus' OR junior_species='americanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platystethus' AND (species='americanus' OR species='americanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platystethus' AND (species='americanus' OR species='americanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platystethus' AND (junior_species='americanus' OR junior_species='americanus')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='Platystethus' AND (species='americanus' OR species='americanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Falagria' AND (junior_species='dissecta' OR junior_species='dissecta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Falagria' AND (species='dissecta' OR species='dissecta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Falagria' AND (species='dissecta' OR species='dissecta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Falagria' AND (junior_species='dissecta' OR junior_species='dissecta')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='Falagria' AND (species='dissecta' OR species='dissecta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxypoda' AND (junior_species='sagulata' OR junior_species='sagulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxypoda' AND (species='sagulata' OR species='sagulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxypoda' AND (species='sagulata' OR species='sagulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxypoda' AND (junior_species='sagulata' OR junior_species='sagulata')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='Oxypoda' AND (species='sagulata' OR species='sagulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxytelus' AND (junior_species='suspectus' OR junior_species='suspectus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxytelus' AND (species='suspectus' OR species='suspectus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxytelus' AND (species='suspectus' OR species='suspectus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxytelus' AND (junior_species='suspectus' OR junior_species='suspectus')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='Oxytelus' AND (species='suspectus' OR species='suspectus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aleochara' AND (junior_species='bipustulata' OR junior_species='bipustulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aleochara' AND (species='bipustulata' OR species='bipustulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aleochara' AND (species='bipustulata' OR species='bipustulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aleochara' AND (junior_species='bipustulata' OR junior_species='bipustulata')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='Aleochara' AND (species='bipustulata' OR species='bipustulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aleochara' AND (junior_species='bimaculata' OR junior_species='bimaculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aleochara' AND (species='bimaculata' OR species='bimaculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aleochara' AND (species='bimaculata' OR species='bimaculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aleochara' AND (junior_species='bimaculata' OR junior_species='bimaculata')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='Aleochara' AND (species='bimaculata' OR species='bimaculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philonthus' AND (junior_species='cruentatus' OR junior_species='cruentatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philonthus' AND (species='cruentatus' OR species='cruentatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philonthus' AND (species='cruentatus' OR species='cruentatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philonthus' AND (junior_species='cruentatus' OR junior_species='cruentatus')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='Philonthus' AND (species='cruentatus' OR species='cruentatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philonthus' AND (junior_species='umbrinus' OR junior_species='umbrinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philonthus' AND (species='umbrinus' OR species='umbrinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philonthus' AND (species='umbrinus' OR species='umbrinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philonthus' AND (junior_species='umbrinus' OR junior_species='umbrinus')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='Philonthus' AND (species='umbrinus' OR species='umbrinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philonthus' AND (junior_species='rectangularis' OR junior_species='rectangularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philonthus' AND (species='rectangularis' OR species='rectangularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philonthus' AND (species='rectangularis' OR species='rectangularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philonthus' AND (junior_species='rectangularis' OR junior_species='rectangularis')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='Philonthus' AND (species='rectangularis' OR species='rectangularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philonthus' AND (junior_species='varians' OR junior_species='varians')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philonthus' AND (species='varians' OR species='varians') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philonthus' AND (species='varians' OR species='varians')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philonthus' AND (junior_species='varians' OR junior_species='varians')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='Philonthus' AND (species='varians' OR species='varians') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gyrohyphus' AND (junior_species='obsidianus' OR junior_species='obsidianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gyrohyphus' AND (species='obsidianus' OR species='obsidianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gyrohyphus' AND (species='obsidianus' OR species='obsidianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gyrohyphus' AND (junior_species='obsidianus' OR junior_species='obsidianus')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='Gyrohyphus' AND (species='obsidianus' OR species='obsidianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ontholestes' AND (junior_species='cingulatus' OR junior_species='cingulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ontholestes' AND (species='cingulatus' OR species='cingulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ontholestes' AND (species='cingulatus' OR species='cingulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ontholestes' AND (junior_species='cingulatus' OR junior_species='cingulatus')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='Ontholestes' AND (species='cingulatus' OR species='cingulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aleocharinae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aleocharinae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aleocharinae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aleocharinae' AND (junior_species='indet.' OR junior_species='indet.')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='Aleocharinae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xantholinini' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xantholinini' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xantholinini' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xantholinini' AND (junior_species='indet.' OR junior_species='indet.')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='Xantholinini' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=689 The Ecological Register: Brookings County (cattle manure)
Brookings County (cattle manure)
Basic information
Sample name: Brookings County (cattle manure)

Reference: H. Kessler, E. U. Balsbaugh Jr, and B. McDaniel. 1974. Faunistic comparison of adult coleoptera recovered from cattle and sheep manure in east central South Dakota. Entomological News 85:67-71 [ER 359]
Geography
Country: United States

State: South Dakota


Coordinate: 44.37° N, -96.79° W
Coordinate basis: based on political unit

Geography comments: coordinate based on county

•
Environment
Habitat: temperate savanna

Substrate: ground surface

WMT: 22.7

CMT: -6.7

MAP: 629.0

Habitat comments: climate data based on station 72651 (Sioux Falls Regional Airport)

Methods
Life forms: beetles,scarab beetles

Sampling methods: no design,hand capture

Sample size: 11178 individuals

Years: 1969

Sampling comments: "collected from bovine dung" between 18 June and 10 September

Metadata
Sample number: 689

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-04-01 11:39:41

Modified: 2015-10-02 10:41:16

Abundance distribution
40 species
5 singletons
total count 11178
extrapolated richness: 48.0
Fisher's α: 5.215
geometric series k: 0.8185
Hurlbert's PIE: 0.8783
Shannon's H: 2.5225
Good's u: 0.9996
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Hister abbreviatus20
Phelister subrotundus31
Hister americanus1
Sphaeridium lunatum521
Sphaeridium scarabaeoides428
Sphaeridium bipustulatum294
Cercyon pygmaeus2262
Cercyon quisquilius1278
Cercyon lateralis136
Cercyon unipunctatus19
Cercyon praetestatus1
Cryptopleurum minutum247
Onthophagus hecate315
Onthophagus pennsylvanicus43
Aphodius haemorrhoidalis824
Aphodius granarius297
Aphodius fimetarius139
Aphodius vittatus45
Aphodius distinctus18
Aphodius ruricola24
Aphodius coloradensis19
Aphodius sterocorosa11
Aphodius fossor10
Aphodius prodromus1
Copris tullius7
Ataenius spretulus103
Platystethus americanus2466
Falagria dissecta797
Oxypoda sagulata412
Oxytelus suspectus5
Aleochara bipustulata40
Aleochara bimaculata17
Philonthus cruentatus162
Philonthus umbrinus25
Philonthus rectangularis40
Philonthus varians13
Gyrohyphus obsidianus1
Ontholestes cingulatus1
Aleocharinae indet.103
Xantholinini indet.2