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=2140 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2140SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2148SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2140 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrida' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acrida' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acrida' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrida' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acrida' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnobothrus' AND (junior_species='lineaalba' OR junior_species='lineaalba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gymnobothrus' AND (species='lineaalba' OR species='lineaalba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnobothrus' AND (species='lineaalba' OR species='lineaalba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnobothrus' AND (junior_species='lineaalba' OR junior_species='lineaalba')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='Gymnobothrus' AND (species='lineaalba' OR species='lineaalba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnobothrus' AND (junior_species='longicornis' OR junior_species='longicornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gymnobothrus' AND (species='longicornis' OR species='longicornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnobothrus' AND (species='longicornis' OR species='longicornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnobothrus' AND (junior_species='longicornis' OR junior_species='longicornis')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='Gymnobothrus' AND (species='longicornis' OR species='longicornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnobothrus' 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='Gymnobothrus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnobothrus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnobothrus' 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='Gymnobothrus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnobothrus' AND (junior_species='temporalis' OR junior_species='temporalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gymnobothrus' AND (species='temporalis' OR species='temporalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnobothrus' AND (species='temporalis' OR species='temporalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnobothrus' AND (junior_species='temporalis' OR junior_species='temporalis')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='Gymnobothrus' AND (species='temporalis' OR species='temporalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontomelus' AND (junior_species='brachypterus' OR junior_species='brachypterus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odontomelus' AND (species='brachypterus' OR species='brachypterus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontomelus' AND (species='brachypterus' OR species='brachypterus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontomelus' AND (junior_species='brachypterus' OR junior_species='brachypterus')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='Odontomelus' AND (species='brachypterus' OR species='brachypterus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthochta' AND (junior_species='dasychemis' OR junior_species='dasychemis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthochta' AND (species='dasychemis' OR species='dasychemis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthochta' AND (species='dasychemis' OR species='dasychemis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthochta' AND (junior_species='dasychemis' OR junior_species='dasychemis')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='Orthochta' AND (species='dasychemis' OR species='dasychemis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Truxalis' AND (junior_species='burtii' OR junior_species='burti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Truxalis' AND (species='burtii' OR species='burti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Truxalis' AND (species='burtii' OR species='burti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Truxalis' AND (junior_species='burtii' OR junior_species='burti')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='Truxalis' AND (species='burtii' OR species='burti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acorypha' AND (junior_species='glaucopsis' OR junior_species='glaucopsis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acorypha' AND (species='glaucopsis' OR species='glaucopsis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acorypha' AND (species='glaucopsis' OR species='glaucopsis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acorypha' AND (junior_species='glaucopsis' OR junior_species='glaucopsis')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='Acorypha' AND (species='glaucopsis' OR species='glaucopsis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachycatanops' AND (junior_species='emalicus' OR junior_species='emalicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachycatanops' AND (species='emalicus' OR species='emalicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachycatanops' AND (species='emalicus' OR species='emalicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachycatanops' AND (junior_species='emalicus' OR junior_species='emalicus')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='Brachycatanops' AND (species='emalicus' OR species='emalicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catantops' AND (junior_species='momboensis' OR junior_species='momboensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catantops' AND (species='momboensis' OR species='momboensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catantops' AND (species='momboensis' OR species='momboensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catantops' AND (junior_species='momboensis' OR junior_species='momboensis')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='Catantops' AND (species='momboensis' OR species='momboensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnansis' AND (junior_species='curvicerca' OR junior_species='curvicerca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ischnansis' AND (species='curvicerca' OR species='curvicerca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ischnansis' AND (species='curvicerca' OR species='curvicerca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnansis' AND (junior_species='curvicerca' OR junior_species='curvicerca')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='Ischnansis' AND (species='curvicerca' OR species='curvicerca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diabolocatantops' AND (junior_species='axillaris' OR junior_species='axillaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diabolocatantops' AND (species='axillaris' OR species='axillaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diabolocatantops' AND (species='axillaris' OR species='axillaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diabolocatantops' AND (junior_species='axillaris' OR junior_species='axillaris')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='Diabolocatantops' AND (species='axillaris' OR species='axillaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epacrocatantops' AND (junior_species='curviverus' OR junior_species='curviverus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epacrocatantops' AND (species='curviverus' OR species='curviverus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epacrocatantops' AND (species='curviverus' OR species='curviverus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epacrocatantops' AND (junior_species='curviverus' OR junior_species='curviverus')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='Epacrocatantops' AND (species='curviverus' OR species='curviverus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaeocatantops' AND (junior_species='decoratus' OR junior_species='decoratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaeocatantops' AND (species='decoratus' OR species='decoratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaeocatantops' AND (species='decoratus' OR species='decoratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaeocatantops' AND (junior_species='decoratus' OR junior_species='decoratus')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='Phaeocatantops' AND (species='decoratus' OR species='decoratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyrtacanthacris' AND (junior_species='tatarica' OR junior_species='tatarica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyrtacanthacris' AND (species='tatarica' OR species='tatarica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyrtacanthacris' AND (species='tatarica' OR species='tatarica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyrtacanthacris' AND (junior_species='tatarica' OR junior_species='tatarica')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='Cyrtacanthacris' AND (species='tatarica' OR species='tatarica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteracris' 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='Heteracris' AND (species='coerulescens' OR species='coerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteracris' AND (species='coerulescens' OR species='coerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteracris' 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='Heteracris' AND (species='coerulescens' OR species='coerulescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metaxymecus' AND (junior_species='gracilipes' OR junior_species='gracilipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metaxymecus' AND (species='gracilipes' OR species='gracilipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metaxymecus' AND (species='gracilipes' OR species='gracilipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metaxymecus' AND (junior_species='gracilipes' OR junior_species='gracilipes')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='Metaxymecus' AND (species='gracilipes' OR species='gracilipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taramassus' AND (junior_species='cunctator' OR junior_species='cunctator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taramassus' AND (species='cunctator' OR species='cunctator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taramassus' AND (species='cunctator' OR species='cunctator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taramassus' AND (junior_species='cunctator' OR junior_species='cunctator')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='Taramassus' AND (species='cunctator' OR species='cunctator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cataloipus' AND (junior_species='oberthuri' OR junior_species='oberthurii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cataloipus' AND (species='oberthuri' OR species='oberthurii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cataloipus' AND (species='oberthuri' OR species='oberthurii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cataloipus' AND (junior_species='oberthuri' OR junior_species='oberthurii')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='Cataloipus' AND (species='oberthuri' OR species='oberthurii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachycrotaphus' AND (junior_species='sjostedi' OR junior_species='sjostedii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachycrotaphus' AND (species='sjostedi' OR species='sjostedii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachycrotaphus' AND (species='sjostedi' OR species='sjostedii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachycrotaphus' AND (junior_species='sjostedi' OR junior_species='sjostedii')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='Brachycrotaphus' AND (species='sjostedi' OR species='sjostedii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesopsis' AND (junior_species='laticornis' OR junior_species='laticornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesopsis' AND (species='laticornis' OR species='laticornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesopsis' AND (species='laticornis' OR species='laticornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesopsis' AND (junior_species='laticornis' OR junior_species='laticornis')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='Mesopsis' AND (species='laticornis' OR species='laticornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochrilidia' AND (junior_species='gracilis' OR junior_species='gracilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochrilidia' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochrilidia' AND (species='gracilis' OR species='gracilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochrilidia' AND (junior_species='gracilis' OR junior_species='gracilis')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='Ochrilidia' AND (species='gracilis' OR species='gracilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pnorisa' AND (junior_species='squalus' OR junior_species='squalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pnorisa' AND (species='squalus' OR species='squalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pnorisa' AND (species='squalus' OR species='squalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pnorisa' AND (junior_species='squalus' OR junior_species='squalus')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='Pnorisa' AND (species='squalus' OR species='squalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhaphotittha' AND (junior_species='levis' OR junior_species='levis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhaphotittha' AND (species='levis' OR species='levis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhaphotittha' AND (species='levis' OR species='levis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhaphotittha' AND (junior_species='levis' OR junior_species='levis')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='Rhaphotittha' AND (species='levis' OR species='levis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhaphotittha' AND (junior_species='subtilis' OR junior_species='subtilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhaphotittha' AND (species='subtilis' OR species='subtilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhaphotittha' AND (species='subtilis' OR species='subtilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhaphotittha' AND (junior_species='subtilis' OR junior_species='subtilis')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='Rhaphotittha' AND (species='subtilis' OR species='subtilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenohippus' AND (junior_species='maculifemur' OR junior_species='maculifemur')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenohippus' AND (species='maculifemur' OR species='maculifemur') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenohippus' AND (species='maculifemur' OR species='maculifemur')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenohippus' AND (junior_species='maculifemur' OR junior_species='maculifemur')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='Stenohippus' AND (species='maculifemur' OR species='maculifemur') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meruana' AND (junior_species='usambarica' OR junior_species='usambarica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meruana' AND (species='usambarica' OR species='usambarica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meruana' AND (species='usambarica' OR species='usambarica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meruana' AND (junior_species='usambarica' OR junior_species='usambarica')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='Meruana' AND (species='usambarica' OR species='usambarica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrotylus' AND (junior_species='meruensis' OR junior_species='meruensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acrotylus' AND (species='meruensis' OR species='meruensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acrotylus' AND (species='meruensis' OR species='meruensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrotylus' AND (junior_species='meruensis' OR junior_species='meruensis')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='Acrotylus' AND (species='meruensis' OR species='meruensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrotylus' AND (junior_species='trifasciatus' OR junior_species='trifasciatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acrotylus' AND (species='trifasciatus' OR species='trifasciatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acrotylus' AND (species='trifasciatus' OR species='trifasciatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrotylus' AND (junior_species='trifasciatus' OR junior_species='trifasciatus')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='Acrotylus' AND (species='trifasciatus' OR species='trifasciatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aiolopus' 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='Aiolopus' AND (species='thalassinus' OR species='thalassinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aiolopus' AND (species='thalassinus' OR species='thalassinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aiolopus' 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='Aiolopus' AND (species='thalassinus' OR species='thalassinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropternis' AND (junior_species='thoracica' OR junior_species='thoracica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteropternis' AND (species='thoracica' OR species='thoracica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteropternis' AND (species='thoracica' OR species='thoracica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropternis' AND (junior_species='thoracica' OR junior_species='thoracica')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='Heteropternis' AND (species='thoracica' OR species='thoracica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morphacris' AND (junior_species='fasciata' OR junior_species='fasciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Morphacris' AND (species='fasciata' OR species='fasciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Morphacris' AND (species='fasciata' OR species='fasciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morphacris' AND (junior_species='fasciata' OR junior_species='fasciata')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='Morphacris' AND (species='fasciata' OR species='fasciata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oedaleus' AND (junior_species='senegalensis' OR junior_species='senegalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oedaleus' AND (species='senegalensis' OR species='senegalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oedaleus' AND (species='senegalensis' OR species='senegalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oedaleus' AND (junior_species='senegalensis' OR junior_species='senegalensis')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='Oedaleus' AND (species='senegalensis' OR species='senegalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnodictya' AND (junior_species='galinieri' OR junior_species='galinierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pycnodictya' AND (species='galinieri' OR species='galinierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pycnodictya' AND (species='galinieri' OR species='galinierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnodictya' AND (junior_species='galinieri' OR junior_species='galinierii')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='Pycnodictya' AND (species='galinieri' OR species='galinierii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trilophidia' AND (junior_species='conturbata' OR junior_species='conturbata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trilophidia' AND (species='conturbata' OR species='conturbata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trilophidia' AND (species='conturbata' OR species='conturbata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trilophidia' AND (junior_species='conturbata' OR junior_species='conturbata')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='Trilophidia' AND (species='conturbata' OR species='conturbata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tristia' AND (junior_species='pallida' OR junior_species='pallida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tristia' AND (species='pallida' OR species='pallida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tristia' AND (species='pallida' OR species='pallida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tristia' AND (junior_species='pallida' OR junior_species='pallida')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='Tristia' AND (species='pallida' OR species='pallida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lobosceliana' 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='Lobosceliana' AND (species='femoralis' OR species='femoralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lobosceliana' AND (species='femoralis' OR species='femoralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lobosceliana' 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='Lobosceliana' AND (species='femoralis' OR species='femoralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrotogonus' AND (junior_species='hemipterus' OR junior_species='hemipterus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrotogonus' AND (species='hemipterus' OR species='hemipterus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrotogonus' AND (species='hemipterus' OR species='hemipterus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrotogonus' AND (junior_species='hemipterus' OR junior_species='hemipterus')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='Chrotogonus' AND (species='hemipterus' OR species='hemipterus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgomorpha' AND (junior_species='conica' OR junior_species='conica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrgomorpha' AND (species='conica' OR species='conica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrgomorpha' AND (species='conica' OR species='conica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgomorpha' AND (junior_species='conica' OR junior_species='conica')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='Pyrgomorpha' AND (species='conica' OR species='conica') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2140 The Ecological Register: Lake Chala
Lake Chala
Basic information
Sample name: Lake Chala

Reference: J. Kuppler, J. Fricke, C. Hemp, I. Steffan-Dewenter, and M. K. Peters. 2015. Conversion of savannah habitats to small-scale agriculture affects grasshopper communities at Mt. Kilimanjaro, Tanzania. Journal of Insect Conservation 19:509-518 [ER 2148]
Geography
Country: Tanzania


Coordinate: 3° 5' 0" S, 37° 21' 30" E
Coordinate basis: stated in text as range

Geography comments: "in the colline savannah zone at Lake Chala and the surrounding agricultural land... on the eastern slopes of Mount Kilimanjaro, Tanzania"
elevation 940to 1163 m

•
Environment
Habitat: tropical/subtropical savanna

Substrate: ground surface

Disturbance: agriculture

MAT: 24.1

MAP: 600.0

Habitat comments: there is "a long rainy season from March to May and a short rainy season in November and December"

Methods
Life forms: orthopterans

Sites: 9

Site area: 0.225

Sampling methods: line transect,sweep nets,visual

Sample size: 1398 individuals

Years: 2010

Days: 144

Sampling comments: "In total, nine plots (three per land use type) were selected to ensure that the heterogeneity of each land use type (natural savannah, ruderal area and corn fields) was well represented. Each plot had an area of 250 m2... Grasshoppers were sampled in six surveys using standardized transect walk methodology between 04th September and 04th December 2010. Each survey was 2–4 days long and each plot was sampled once within each survey" (approximate effort 9 plots x 6 surveys x 3 days); "Each plot was covered by twelve parallel transects, each being 50 m long and 4 m wide. The transects were paced slowly for 1 hour and adult grasshoppers spotted sitting on herbage and on the ground were collected with sweep nets or by hand and killed with cyanide. Large species with good flying abilities were mostly counted by sight"

Metadata
Sample number: 2140

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-07-24 19:45:27

Modified: 2016-07-24 09:45:27

Abundance distribution
40 species
12 singletons
total count 1398
extrapolated richness: 62.8
Fisher's α: 7.678
geometric series k: 0.8595
Hurlbert's PIE: 0.8815
Shannon's H: 2.6350
Good's u: 0.9914
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Acrida 'bicolor'1
Gymnobothrus lineaalba1
Gymnobothrus longicornis1
Gymnobothrus sp.3
Gymnobothrus temporalis flexuosus12
Odontomelus brachypterus1
Orthochta dasychemis dasychemis79
Truxalis burtii36
Acorypha glaucopsis19
Brachycatanops emalicus1
Catantops momboensis momboensis60
Ischnansis curvicerca1
Diabolocatantops axillaris1
Epacrocatantops curviverus113
Phaeocatantops decoratus decoratus1
Cyrtacanthacris tatarica tatarica37
Heteracris coerulescens1
Metaxymecus gracilipes17
Taramassus cunctator1
Cataloipus oberthuri oberthuri15
Brachycrotaphus sjostedi24
Mesopsis laticornis35
Ochrilidia gracilis nyuki4
Pnorisa squalus squalus45
Rhaphotittha levis367
Rhaphotittha subtilis6
Stenohippus maculifemur73
Meruana usambarica3
Acrotylus meruensis219
Acrotylus trifasciatus trifasciatus34
Aiolopus thalassinus1
Heteropternis thoracica42
Morphacris fasciata8
Oedaleus senegalensis6
Pycnodictya galinieri9
Trilophidia conturbata4
Tristia pallida6
Lobosceliana femoralis1
Chrotogonus hemipterus100
Pyrgomorpha conica10