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=636 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=636SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=322SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=636 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allogymnopleurus' 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='Allogymnopleurus' AND (species='umbrinus' OR species='umbrinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allogymnopleurus' AND (species='umbrinus' OR species='umbrinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allogymnopleurus' 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='Allogymnopleurus' AND (species='umbrinus' OR species='umbrinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allogymnopleurus' AND (junior_species='youngai' OR junior_species='youngaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allogymnopleurus' AND (species='youngai' OR species='youngaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allogymnopleurus' AND (species='youngai' OR species='youngaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allogymnopleurus' AND (junior_species='youngai' OR junior_species='youngaii')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='youngai' OR species='youngaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anachalcos' AND (junior_species='aurescens' OR junior_species='aurescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anachalcos' AND (species='aurescens' OR species='aurescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anachalcos' AND (species='aurescens' OR species='aurescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anachalcos' AND (junior_species='aurescens' OR junior_species='aurescens')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='aurescens' OR species='aurescens') 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='Anachalcos' AND (junior_species='cupreus' OR junior_species='cupreus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anachalcos' AND (species='cupreus' OR species='cupreus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anachalcos' AND (species='cupreus' OR species='cupreus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anachalcos' AND (junior_species='cupreus' OR junior_species='cupreus')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='cupreus' OR species='cupreus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anachalcos' AND (junior_species='suturalis' OR junior_species='suturalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anachalcos' AND (species='suturalis' OR species='suturalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anachalcos' AND (species='suturalis' OR species='suturalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anachalcos' AND (junior_species='suturalis' OR junior_species='suturalis')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='suturalis' OR species='suturalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garreta' AND (junior_species='nitens' OR junior_species='nitens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garreta' AND (species='nitens' OR species='nitens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garreta' AND (species='nitens' OR species='nitens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garreta' AND (junior_species='nitens' OR junior_species='nitens')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='Garreta' AND (species='nitens' OR species='nitens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnopleurus' AND (junior_species='coerulescens' OR junior_species='coerulescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gymnopleurus' AND (species='coerulescens' OR species='coerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnopleurus' AND (species='coerulescens' OR species='coerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnopleurus' AND (junior_species='coerulescens' OR junior_species='coerulescens')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='coerulescens' OR species='coerulescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnopleurus' 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='Gymnopleurus' AND (species='puncticollis' OR species='puncticollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnopleurus' AND (species='puncticollis' OR species='puncticollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnopleurus' 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='Gymnopleurus' AND (species='puncticollis' OR species='puncticollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neosisyphus' AND (junior_species='armatus' OR junior_species='armatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neosisyphus' AND (species='armatus' OR species='armatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neosisyphus' AND (species='armatus' OR species='armatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neosisyphus' AND (junior_species='armatus' OR junior_species='armatus')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='armatus' OR species='armatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neosisyphus' AND (junior_species='gladiator' OR junior_species='gladiator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neosisyphus' AND (species='gladiator' OR species='gladiator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neosisyphus' AND (species='gladiator' OR species='gladiator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neosisyphus' AND (junior_species='gladiator' OR junior_species='gladiator')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='gladiator' OR species='gladiator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scarabaeus' AND (junior_species='goryi' OR junior_species='goryii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scarabaeus' AND (species='goryi' OR species='goryii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scarabaeus' AND (species='goryi' OR species='goryii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scarabaeus' AND (junior_species='goryi' OR junior_species='goryii')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='goryi' OR species='goryii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='biarmatus' OR junior_species='biarmatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sisyphus' AND (species='biarmatus' OR species='biarmatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sisyphus' AND (species='biarmatus' OR species='biarmatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='biarmatus' OR junior_species='biarmatus')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='biarmatus' OR species='biarmatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='gazanus' OR junior_species='gazanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sisyphus' AND (species='gazanus' OR species='gazanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sisyphus' AND (species='gazanus' OR species='gazanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='gazanus' OR junior_species='gazanus')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='gazanus' OR species='gazanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='goryi' OR junior_species='goryii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sisyphus' AND (species='goryi' OR species='goryii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sisyphus' AND (species='goryi' OR species='goryii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='goryi' OR junior_species='goryii')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='goryi' OR species='goryii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='seminulum' OR junior_species='seminulum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sisyphus' AND (species='seminulum' OR species='seminulum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sisyphus' AND (species='seminulum' OR species='seminulum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisyphus' AND (junior_species='seminulum' OR junior_species='seminulum')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='seminulum' OR species='seminulum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caccobius' AND (junior_species='anthracites' OR junior_species='anthracites')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caccobius' AND (species='anthracites' OR species='anthracites') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caccobius' AND (species='anthracites' OR species='anthracites')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caccobius' AND (junior_species='anthracites' OR junior_species='anthracites')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='anthracites' OR species='anthracites') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caccobius' AND (junior_species='auberti' OR junior_species='aubertii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caccobius' AND (species='auberti' OR species='aubertii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caccobius' AND (species='auberti' OR species='aubertii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caccobius' AND (junior_species='auberti' OR junior_species='aubertii')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='auberti' OR species='aubertii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caccobius' AND (junior_species='ivorensis' OR junior_species='ivorensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caccobius' AND (species='ivorensis' OR species='ivorensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caccobius' AND (species='ivorensis' OR species='ivorensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caccobius' AND (junior_species='ivorensis' OR junior_species='ivorensis')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='ivorensis' OR species='ivorensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caccobius' AND (junior_species='mirabilepunctatus' OR junior_species='mirabilepunctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caccobius' AND (species='mirabilepunctatus' OR species='mirabilepunctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caccobius' AND (species='mirabilepunctatus' OR species='mirabilepunctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caccobius' AND (junior_species='mirabilepunctatus' OR junior_species='mirabilepunctatus')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='mirabilepunctatus' OR species='mirabilepunctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caccobius' AND (junior_species='punctatissimus' OR junior_species='punctatissimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caccobius' AND (species='punctatissimus' OR species='punctatissimus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caccobius' AND (species='punctatissimus' OR species='punctatissimus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caccobius' AND (junior_species='punctatissimus' OR junior_species='punctatissimus')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='punctatissimus' OR species='punctatissimus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharsius' AND (junior_species='eteocles' OR junior_species='eteocles')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catharsius' AND (species='eteocles' OR species='eteocles') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catharsius' AND (species='eteocles' OR species='eteocles')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharsius' AND (junior_species='eteocles' OR junior_species='eteocles')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='eteocles' OR species='eteocles') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharsius' AND (junior_species='ninus' OR junior_species='ninus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catharsius' AND (species='ninus' OR species='ninus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catharsius' AND (species='ninus' OR species='ninus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharsius' AND (junior_species='ninus' OR junior_species='ninus')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='ninus' OR species='ninus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharsius' AND (junior_species='pseudolycaon' OR junior_species='pseudolycaon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catharsius' AND (species='pseudolycaon' OR species='pseudolycaon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catharsius' AND (species='pseudolycaon' OR species='pseudolycaon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharsius' AND (junior_species='pseudolycaon' OR junior_species='pseudolycaon')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='pseudolycaon' OR species='pseudolycaon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharsius' AND (junior_species='sesostris' OR junior_species='sesostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catharsius' AND (species='sesostris' OR species='sesostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catharsius' AND (species='sesostris' OR species='sesostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharsius' AND (junior_species='sesostris' OR junior_species='sesostris')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='sesostris' OR species='sesostris') 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='Latodrepanus' AND (junior_species='laticollis' OR junior_species='laticollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Latodrepanus' AND (species='laticollis' OR species='laticollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Latodrepanus' AND (species='laticollis' OR species='laticollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Latodrepanus' AND (junior_species='laticollis' OR junior_species='laticollis')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='Latodrepanus' AND (species='laticollis' OR species='laticollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euoniticellus' AND (junior_species='parvus' OR junior_species='parvus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euoniticellus' AND (species='parvus' OR species='parvus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euoniticellus' AND (species='parvus' OR species='parvus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euoniticellus' AND (junior_species='parvus' OR junior_species='parvus')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='parvus' OR species='parvus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euonthophagus' AND (junior_species='carbonarius' OR junior_species='carbonarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euonthophagus' AND (species='carbonarius' OR species='carbonarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euonthophagus' AND (species='carbonarius' OR species='carbonarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euonthophagus' AND (junior_species='carbonarius' OR junior_species='carbonarius')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='Euonthophagus' AND (species='carbonarius' OR species='carbonarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyalonthophagus' AND (junior_species='pseucoalcyon' OR junior_species='pseucoalcyon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyalonthophagus' AND (species='pseucoalcyon' OR species='pseucoalcyon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyalonthophagus' AND (species='pseucoalcyon' OR species='pseucoalcyon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyalonthophagus' AND (junior_species='pseucoalcyon' OR junior_species='pseucoalcyon')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='pseucoalcyon' OR species='pseucoalcyon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metacatharsius' AND (junior_species='inermis' OR junior_species='inermis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metacatharsius' AND (species='inermis' OR species='inermis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metacatharsius' AND (species='inermis' OR species='inermis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metacatharsius' AND (junior_species='inermis' OR junior_species='inermis')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='inermis' OR species='inermis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Milichus' AND (junior_species='apicalis' OR junior_species='apicalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Milichus' AND (species='apicalis' OR species='apicalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Milichus' AND (species='apicalis' OR species='apicalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Milichus' AND (junior_species='apicalis' OR junior_species='apicalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Milichus' AND (species='apicalis' OR species='apicalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Milichus' AND (junior_species='serratus' OR junior_species='serratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Milichus' AND (species='serratus' OR species='serratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Milichus' AND (species='serratus' OR species='serratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Milichus' AND (junior_species='serratus' OR junior_species='serratus')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='Milichus' AND (species='serratus' OR species='serratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onitis' AND (junior_species='cupreus' OR junior_species='cupreus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onitis' AND (species='cupreus' OR species='cupreus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onitis' AND (species='cupreus' OR species='cupreus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onitis' AND (junior_species='cupreus' OR junior_species='cupreus')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='cupreus' OR species='cupreus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onitis' AND (junior_species='multidentatus' OR junior_species='multidentatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onitis' AND (species='multidentatus' OR species='multidentatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onitis' AND (species='multidentatus' OR species='multidentatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onitis' AND (junior_species='multidentatus' OR junior_species='multidentatus')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='multidentatus' OR species='multidentatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='atridorsis' OR junior_species='atridorsis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='atridorsis' OR species='atridorsis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='atridorsis' OR species='atridorsis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='atridorsis' OR junior_species='atridorsis')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='atridorsis' OR species='atridorsis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='bandamai' OR junior_species='bandamaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='bandamai' OR species='bandamaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='bandamai' OR species='bandamaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='bandamai' OR junior_species='bandamaii')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='bandamai' OR species='bandamaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='bidens' OR junior_species='bidens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='bidens' OR species='bidens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='bidens' OR species='bidens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='bidens' OR junior_species='bidens')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='bidens' OR species='bidens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='borassi' OR junior_species='borassii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='borassi' OR species='borassii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='borassi' OR species='borassii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='borassi' OR junior_species='borassii')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='borassi' OR species='borassii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='cribellum' OR junior_species='cribellum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='cribellum' OR species='cribellum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='cribellum' OR species='cribellum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='cribellum' OR junior_species='cribellum')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='cribellum' OR species='cribellum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='cupreus' OR junior_species='cupreus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='cupreus' OR species='cupreus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='cupreus' OR species='cupreus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='cupreus' OR junior_species='cupreus')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='cupreus' OR species='cupreus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='cyanochlorus' OR junior_species='cyanochlorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='cyanochlorus' OR species='cyanochlorus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='cyanochlorus' OR species='cyanochlorus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='cyanochlorus' OR junior_species='cyanochlorus')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='cyanochlorus' OR species='cyanochlorus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='decorsei' OR junior_species='decorseii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='decorsei' OR species='decorseii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='decorsei' OR species='decorseii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='decorsei' OR junior_species='decorseii')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='decorsei' OR species='decorseii') 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='flaviclava' OR junior_species='flaviclava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='flaviclava' OR species='flaviclava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='flaviclava' OR species='flaviclava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='flaviclava' OR junior_species='flaviclava')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='flaviclava' OR species='flaviclava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='flexicornis' OR junior_species='flexicornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='flexicornis' OR species='flexicornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='flexicornis' OR species='flexicornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='flexicornis' OR junior_species='flexicornis')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='flexicornis' OR species='flexicornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='lobi' OR junior_species='lobii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='lobi' OR species='lobii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='lobi' OR species='lobii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='lobi' OR junior_species='lobii')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='lobi' OR species='lobii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='longipilis' OR junior_species='longipilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='longipilis' OR species='longipilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='longipilis' OR species='longipilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='longipilis' OR junior_species='longipilis')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='longipilis' OR species='longipilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='lutaticollis' OR junior_species='lutaticollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='lutaticollis' OR species='lutaticollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='lutaticollis' OR species='lutaticollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='lutaticollis' OR junior_species='lutaticollis')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='lutaticollis' OR species='lutaticollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='micros' OR junior_species='micros')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='micros' OR species='micros') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='micros' OR species='micros')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='micros' OR junior_species='micros')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='micros' OR species='micros') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='mucronatus' OR junior_species='mucronatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='mucronatus' OR species='mucronatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='mucronatus' OR species='mucronatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='mucronatus' OR junior_species='mucronatus')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='mucronatus' OR species='mucronatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='mucronifer' OR junior_species='mucronifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='mucronifer' OR species='mucronifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='mucronifer' OR species='mucronifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='mucronifer' OR junior_species='mucronifer')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='mucronifer' OR species='mucronifer') 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='reticulatus' OR junior_species='reticulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='reticulatus' OR species='reticulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='reticulatus' OR species='reticulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='reticulatus' OR junior_species='reticulatus')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='reticulatus' OR species='reticulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='rufonotatus' OR junior_species='rufonotatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='rufonotatus' OR species='rufonotatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='rufonotatus' OR species='rufonotatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='rufonotatus' OR junior_species='rufonotatus')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='rufonotatus' OR species='rufonotatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='sellatulus' OR junior_species='sellatulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='sellatulus' OR species='sellatulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='sellatulus' OR species='sellatulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='sellatulus' OR junior_species='sellatulus')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='sellatulus' OR species='sellatulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='stehliki' OR junior_species='stehlikii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='stehliki' OR species='stehlikii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='stehliki' OR species='stehlikii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='stehliki' OR junior_species='stehlikii')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='stehliki' OR species='stehlikii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='tripartitus' OR junior_species='tripartitus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='tripartitus' OR species='tripartitus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='tripartitus' OR species='tripartitus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='tripartitus' OR junior_species='tripartitus')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='tripartitus' OR species='tripartitus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='ulula' OR junior_species='ulula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='ulula' OR species='ulula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='ulula' OR species='ulula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='ulula' OR junior_species='ulula')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='ulula' OR species='ulula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalops' AND (junior_species='iphis' OR junior_species='iphis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phalops' AND (species='iphis' OR species='iphis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phalops' AND (species='iphis' OR species='iphis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalops' AND (junior_species='iphis' OR junior_species='iphis')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='Phalops' AND (species='iphis' OR species='iphis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalops' AND (junior_species='vanellus' OR junior_species='vanellus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phalops' AND (species='vanellus' OR species='vanellus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phalops' AND (species='vanellus' OR species='vanellus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalops' AND (junior_species='vanellus' OR junior_species='vanellus')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='Phalops' AND (species='vanellus' OR species='vanellus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proagoderus' AND (junior_species='auratus' OR junior_species='auratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Proagoderus' AND (species='auratus' OR species='auratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Proagoderus' AND (species='auratus' OR species='auratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proagoderus' AND (junior_species='auratus' OR junior_species='auratus')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='auratus' OR species='auratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proagoderus' AND (junior_species='yvescambeforti' OR junior_species='yvescambefortii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Proagoderus' AND (species='yvescambeforti' OR species='yvescambefortii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Proagoderus' AND (species='yvescambeforti' OR species='yvescambefortii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proagoderus' AND (junior_species='yvescambeforti' OR junior_species='yvescambefortii')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='yvescambeforti' OR species='yvescambefortii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiniocellus' AND (junior_species='praetermissus' OR junior_species='praetermissus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tiniocellus' AND (species='praetermissus' OR species='praetermissus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tiniocellus' AND (species='praetermissus' OR species='praetermissus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiniocellus' AND (junior_species='praetermissus' OR junior_species='praetermissus')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='Tiniocellus' AND (species='praetermissus' OR species='praetermissus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=636 The Ecological Register: Lola Field Station (savanna)
Lola Field Station (savanna)
Basic information
Sample name: Lola Field Station (savanna)

Sample aka: Comoé National Park

Reference: B. K. Kunz and F.-T. Krell. 2011. Habitat differences in dung beetle assemblages in an African savanna forest ecotone: implications for secondary seed dispersal. Integrative Zoology 6:81-96 [ER 322]
Geography
Country: Ivory Coast


Coordinate: 8° 45' 6" N, 3° 48' 59" W
Coordinate basis: stated in text

Geography comments: elevation range 250 to 300 m

•
Environment
Habitat: tropical/subtropical savanna

Protection: national/state park

Substrate: ground surface

MAT: 26.3

MAP: 1053.0

Habitat comments: "an ecotone between the semi-deciduous rainforests farther south and the savanna woodlands in the northern Sudanian zone"

Methods
Life forms: scarab beetles

Sampling methods: no design,hand capture

Sample size: 2367 individuals

Years: 1999, 2000

Sampling comments: beetles were directly collected from 32 olive baboon dung piles

Metadata
Sample number: 636

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-28 15:17:54

Modified: 2015-09-29 10:20:28

Abundance distribution
64 species
16 singletons
total count 2367
extrapolated richness: 101.3
Fisher's α: 12.123
geometric series k: 0.9016
Hurlbert's PIE: 0.8862
Shannon's H: 2.8522
Good's u: 0.9932
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Allogymnopleurus umbrinus15
Allogymnopleurus youngai1
Anachalcos aurescens5
Anachalcos convexus15
Anachalcos cupreus1
Anachalcos suturalis31
Garreta nitens12
Gymnopleurus coerulescens17
Gymnopleurus puncticollis141
Neosisyphus armatus16
Neosisyphus gladiator3
Scarabaeus goryi2
Sisyphus biarmatus47
Sisyphus gazanus13
Sisyphus goryi683
Sisyphus seminulum91
Caccobius anthracites3
Caccobius auberti34
Caccobius ivorensis30
Caccobius mirabilepunctatus24
Caccobius punctatissimus1
Catharsius eteocles2
Catharsius ninus1
Catharsius pseudolycaon1
Catharsius sesostris1
Digitonthophagus gazella1
Latodrepanus laticollis1
Euoniticellus parvus1
Euonthophagus carbonarius4
Hyalonthophagus pseucoalcyon1
Metacatharsius inermis2
Milichus apicalis2
Milichus serratus5
Onitis cupreus21
Onitis multidentatus2
Onthophagus atridorsis24
Onthophagus bandamai4
Onthophagus bidens2
Onthophagus borassi6
Onthophagus cribellum5
Onthophagus cupreus6
Onthophagus cyanochlorus26
Onthophagus decorsei2
Onthophagus fimetarius62
Onthophagus flaviclava64
Onthophagus flexicornis28
Onthophagus lobi1
Onthophagus longipilis1
Onthophagus lutaticollis8
Onthophagus micros1
Onthophagus mucronatus158
Onthophagus mucronifer114
Onthophagus pullus40
Onthophagus reticulatus1
Onthophagus rufonotatus199
Onthophagus sellatulus3
Onthophagus stehliki87
Onthophagus tripartitus12
Onthophagus ulula150
Phalops iphis1
Phalops vanellus1
Proagoderus auratus4
Proagoderus yvescambeforti3
Tiniocellus praetermissus124