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=2172 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2172SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2165SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2172 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='dawsoni' OR junior_species='dawsonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='dawsoni' OR species='dawsonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='dawsoni' OR species='dawsonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='dawsoni' OR junior_species='dawsonii')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='Melanoplus' AND (species='dawsoni' OR species='dawsonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camnula' AND (junior_species='pellucida' OR junior_species='pellucida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camnula' AND (species='pellucida' OR species='pellucida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camnula' AND (species='pellucida' OR species='pellucida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camnula' AND (junior_species='pellucida' OR junior_species='pellucida')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='Camnula' AND (species='pellucida' OR species='pellucida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chorthippus' AND (junior_species='curtipennis' OR junior_species='curtipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chorthippus' AND (species='curtipennis' OR species='curtipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chorthippus' AND (species='curtipennis' OR species='curtipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chorthippus' AND (junior_species='curtipennis' OR junior_species='curtipennis')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='Chorthippus' AND (species='curtipennis' OR species='curtipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Encoptolophus' AND (junior_species='sordidus' OR junior_species='sordidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Encoptolophus' AND (species='sordidus' OR species='sordidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Encoptolophus' AND (species='sordidus' OR species='sordidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Encoptolophus' AND (junior_species='sordidus' OR junior_species='sordidus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Encoptolophus' AND (species='sordidus' OR species='sordidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='infantilis' OR junior_species='infantilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='infantilis' OR species='infantilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='infantilis' OR species='infantilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='infantilis' OR junior_species='infantilis')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='Melanoplus' AND (species='infantilis' OR species='infantilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='sanguinipes' OR junior_species='sanguinipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='sanguinipes' OR species='sanguinipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='sanguinipes' OR species='sanguinipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='sanguinipes' OR junior_species='sanguinipes')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='Melanoplus' AND (species='sanguinipes' OR species='sanguinipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ageneotettix' AND (junior_species='deorum' OR junior_species='deorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ageneotettix' AND (species='deorum' OR species='deorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ageneotettix' AND (species='deorum' OR species='deorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ageneotettix' AND (junior_species='deorum' OR junior_species='deorum')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='Ageneotettix' AND (species='deorum' OR species='deorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphitornus' AND (junior_species='coloradus' OR junior_species='coloradus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphitornus' AND (species='coloradus' OR species='coloradus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphitornus' AND (species='coloradus' OR species='coloradus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphitornus' AND (junior_species='coloradus' OR junior_species='coloradus')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='Amphitornus' AND (species='coloradus' OR species='coloradus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phlibostroma' AND (junior_species='quadrimaculatum' OR junior_species='quadrimaculatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phlibostroma' AND (species='quadrimaculatum' OR species='quadrimaculatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phlibostroma' AND (species='quadrimaculatum' OR species='quadrimaculatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phlibostroma' AND (junior_species='quadrimaculatum' OR junior_species='quadrimaculatum')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='Phlibostroma' AND (species='quadrimaculatum' OR species='quadrimaculatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='gladstoni' OR junior_species='gladstonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='gladstoni' OR species='gladstonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='gladstoni' OR species='gladstonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='gladstoni' OR junior_species='gladstonii')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='Melanoplus' AND (species='gladstoni' OR species='gladstonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aeropedellus' AND (junior_species='clavatus' OR junior_species='clavatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aeropedellus' AND (species='clavatus' OR species='clavatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aeropedellus' AND (species='clavatus' OR species='clavatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aeropedellus' AND (junior_species='clavatus' OR junior_species='clavatus')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='Aeropedellus' AND (species='clavatus' OR species='clavatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='bivittatus' OR junior_species='bivittatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='bivittatus' OR species='bivittatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='bivittatus' OR species='bivittatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='bivittatus' OR junior_species='bivittatus')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='Melanoplus' AND (species='bivittatus' OR species='bivittatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoetaliotes' AND (junior_species='nebrascensis' OR junior_species='nebrascensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoetaliotes' AND (species='nebrascensis' OR species='nebrascensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoetaliotes' AND (species='nebrascensis' OR species='nebrascensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoetaliotes' AND (junior_species='nebrascensis' OR junior_species='nebrascensis')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='Phoetaliotes' AND (species='nebrascensis' OR species='nebrascensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arphia' AND (junior_species='pseudonietana' OR junior_species='pseudonietana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arphia' AND (species='pseudonietana' OR species='pseudonietana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arphia' AND (species='pseudonietana' OR species='pseudonietana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arphia' AND (junior_species='pseudonietana' OR junior_species='pseudonietana')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='Arphia' AND (species='pseudonietana' OR species='pseudonietana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metator' AND (junior_species='pardalinus' OR junior_species='pardalinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metator' AND (species='pardalinus' OR species='pardalinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metator' AND (species='pardalinus' OR species='pardalinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metator' AND (junior_species='pardalinus' OR junior_species='pardalinus')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='Metator' AND (species='pardalinus' OR species='pardalinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bruneria' AND (junior_species='brunnea' OR junior_species='brunnea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bruneria' AND (species='brunnea' OR species='brunnea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bruneria' AND (species='brunnea' OR species='brunnea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bruneria' AND (junior_species='brunnea' OR junior_species='brunnea')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='Bruneria' AND (species='brunnea' OR species='brunnea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aulocara' AND (junior_species='elliotti' OR junior_species='elliottii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aulocara' AND (species='elliotti' OR species='elliottii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aulocara' AND (species='elliotti' OR species='elliottii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aulocara' AND (junior_species='elliotti' OR junior_species='elliottii')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='Aulocara' AND (species='elliotti' OR species='elliottii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='packardii' OR junior_species='packardi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='packardii' OR species='packardi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='packardii' OR species='packardi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='packardii' OR junior_species='packardi')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='Melanoplus' AND (species='packardii' OR species='packardi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trimerotropis' AND (junior_species='campestris' OR junior_species='campestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trimerotropis' AND (species='campestris' OR species='campestris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trimerotropis' AND (species='campestris' OR species='campestris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trimerotropis' AND (junior_species='campestris' OR junior_species='campestris')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='Trimerotropis' AND (species='campestris' OR species='campestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aulocara' AND (junior_species='femoratum' OR junior_species='femoratum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aulocara' AND (species='femoratum' OR species='femoratum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aulocara' AND (species='femoratum' OR species='femoratum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aulocara' AND (junior_species='femoratum' OR junior_species='femoratum')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='Aulocara' AND (species='femoratum' OR species='femoratum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psoloessa' AND (junior_species='delicatula' OR junior_species='delicatula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psoloessa' AND (species='delicatula' OR species='delicatula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psoloessa' AND (species='delicatula' OR species='delicatula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psoloessa' AND (junior_species='delicatula' OR junior_species='delicatula')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='Psoloessa' AND (species='delicatula' OR species='delicatula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='femurrubrum' OR junior_species='femurrubrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='femurrubrum' OR species='femurrubrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='femurrubrum' OR species='femurrubrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='femurrubrum' OR junior_species='femurrubrum')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='Melanoplus' AND (species='femurrubrum' OR species='femurrubrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='oregonensis' OR junior_species='oregonensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='oregonensis' OR species='oregonensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='oregonensis' OR species='oregonensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='oregonensis' OR junior_species='oregonensis')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='Melanoplus' AND (species='oregonensis' OR species='oregonensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachyrhachys' AND (junior_species='kiowa' OR junior_species='kiowa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachyrhachys' AND (species='kiowa' OR species='kiowa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachyrhachys' AND (species='kiowa' OR species='kiowa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachyrhachys' AND (junior_species='kiowa' OR junior_species='kiowa')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='Trachyrhachys' AND (species='kiowa' OR species='kiowa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spharagemon' AND (junior_species='equale' OR junior_species='equale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spharagemon' AND (species='equale' OR species='equale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spharagemon' AND (species='equale' OR species='equale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spharagemon' AND (junior_species='equale' OR junior_species='equale')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='Spharagemon' AND (species='equale' OR species='equale') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Derotmema' AND (junior_species='haydenii' OR junior_species='haydeni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Derotmema' AND (species='haydenii' OR species='haydeni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Derotmema' AND (species='haydenii' OR species='haydeni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Derotmema' AND (junior_species='haydenii' OR junior_species='haydeni')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='Derotmema' AND (species='haydenii' OR species='haydeni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrix' 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='Tetrix' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetrix' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrix' 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='Tetrix' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2172 The Ecological Register: Coalhurst
Coalhurst
Basic information
Sample name: Coalhurst

Reference: J. M. Hardman and S. Smoliak. 1982. The relative impact of various grasshopper species on Stipa-Agropyron mixed prairie and fescue prairie in southern Alberta. Journal of Range Management 35(2):171-176 [ER 2165]
Geography
Country: Canada

State: Alberta


Coordinate: 49° 45' N, 112° 56' W
Coordinate basis: based on nearby landmark

Geography comments: "8 km west of Lethbridge" (coordinate based on Coalhurst)

•
Environment
Habitat: temperate savanna

Substrate: ground surface

Habitat comments: "Stipa-Agropyron prairie"

Methods
Life forms: orthopterans

Sampling methods: no design,sweep nets

Sample size: 2731 individuals

Years: 1971 - 1976, 1978, 1979

Seasons: summer

Sampling comments: "Grasshoppers were sampled annually in late August... The samples were obtained by making 50-1,000 semi-circular sweeps with a 34-cm diam. net at the rate of one sweep per step"
text states there are 2796 individuals but this does not square with the mean counts in Table 1, which clearly imply there were 800 sweeps and therefore about 2731 captures; this is consistent with there having been 50 sweeps during each of the eight field seasons, so 800 sweeps are assumed

Metadata
Sample number: 2172

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-08-04 09:53:53

Modified: 2016-08-03 23:56:26

Abundance distribution
27 species
3 singletons
total count 2731
extrapolated richness: 34.3
Fisher's α: 4.161
geometric series k: 0.7884
Hurlbert's PIE: 0.8849
Shannon's H: 2.4097
Good's u: 0.9989
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Melanoplus dawsoni2
Camnula pellucida14
Chorthippus curtipennis5
Encoptolophus sordidus costalis483
Melanoplus infantilis463
Melanoplus sanguinipes299
Ageneotettix deorum deorum365
Amphitornus coloradus coloradus317
Phlibostroma quadrimaculatum216
Melanoplus gladstoni119
Aeropedellus clavatus67
Melanoplus bivittatus12
Phoetaliotes nebrascensis77
Arphia pseudonietana pseudonietana58
Metator pardalinus69
Bruneria brunnea69
Aulocara elliotti45
Melanoplus packardii16
Trimerotropis campestris1
Aulocara femoratum10
Psoloessa delicatula delicatula10
Melanoplus femurrubrum femurrubrum5
Melanoplus oregonensis2
Trachyrhachys kiowa kiowa3
Spharagemon equale2
Derotmema haydenii haydenii1
Tetrix sp.1