Coordinate: 39° 12' N, 96° 36' W
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=2169 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2169SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2164SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2169 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orphulella' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orphulella' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orphulella' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orphulella' AND (junior_species='spp.' OR junior_species='spp.')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='Orphulella' AND (species='spp.' OR species='spp.') 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='Melanoplus' AND (junior_species='mexicanus' OR junior_species='mexicanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='mexicanus' OR species='mexicanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='mexicanus' OR species='mexicanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='mexicanus' OR junior_species='mexicanus')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='mexicanus' OR species='mexicanus') 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='Mermiria' 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='Mermiria' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mermiria' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mermiria' 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='Mermiria' AND (species='sp.' OR species='sp.') 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='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='Syrbula' AND (junior_species='admirabilis' OR junior_species='admirabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syrbula' AND (species='admirabilis' OR species='admirabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syrbula' AND (species='admirabilis' OR species='admirabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syrbula' AND (junior_species='admirabilis' OR junior_species='admirabilis')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='Syrbula' AND (species='admirabilis' OR species='admirabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardalophora' AND (junior_species='haldemani' OR junior_species='haldemanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pardalophora' AND (species='haldemani' OR species='haldemanii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pardalophora' AND (species='haldemani' OR species='haldemanii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardalophora' AND (junior_species='haldemani' OR junior_species='haldemanii')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='Pardalophora' AND (species='haldemani' OR species='haldemanii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippiscus' AND (junior_species='rugosus' OR junior_species='rugosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hippiscus' AND (species='rugosus' OR species='rugosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hippiscus' AND (species='rugosus' OR species='rugosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippiscus' AND (junior_species='rugosus' OR junior_species='rugosus')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='Hippiscus' AND (species='rugosus' OR species='rugosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='confusus' OR junior_species='confusus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='confusus' OR species='confusus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='confusus' OR species='confusus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='confusus' OR junior_species='confusus')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='confusus' OR species='confusus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='differentialis' OR junior_species='differentialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='differentialis' OR species='differentialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='differentialis' OR species='differentialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='differentialis' OR junior_species='differentialis')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='differentialis' OR species='differentialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypochlora' AND (junior_species='alba' OR junior_species='alba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypochlora' AND (species='alba' OR species='alba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypochlora' AND (species='alba' OR species='alba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypochlora' AND (junior_species='alba' OR junior_species='alba')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='Hypochlora' AND (species='alba' OR species='alba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperotettix' AND (junior_species='viridis' OR junior_species='viridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hesperotettix' AND (species='viridis' OR species='viridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hesperotettix' AND (species='viridis' OR species='viridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperotettix' AND (junior_species='viridis' OR junior_species='viridis')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='Hesperotettix' AND (species='viridis' OR species='viridis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opeia' AND (junior_species='obscura' OR junior_species='obscura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Opeia' AND (species='obscura' OR species='obscura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Opeia' AND (species='obscura' OR species='obscura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opeia' AND (junior_species='obscura' OR junior_species='obscura')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='Opeia' AND (species='obscura' OR species='obscura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachyrhachis' 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='Trachyrhachis' AND (species='kiowa' OR species='kiowa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachyrhachis' AND (species='kiowa' OR species='kiowa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachyrhachis' 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='Trachyrhachis' AND (species='kiowa' OR species='kiowa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperotettix' AND (junior_species='viridis' OR junior_species='viridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hesperotettix' AND (species='viridis' OR species='viridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hesperotettix' AND (species='viridis' OR species='viridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperotettix' AND (junior_species='viridis' OR junior_species='viridis')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='Hesperotettix' AND (species='viridis' OR species='viridis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eritettix' AND (junior_species='simplex' OR junior_species='simplex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eritettix' AND (species='simplex' OR species='simplex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eritettix' AND (species='simplex' OR species='simplex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eritettix' AND (junior_species='simplex' OR junior_species='simplex')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='Eritettix' AND (species='simplex' OR species='simplex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chortophaga' AND (junior_species='viridifasciata' OR junior_species='viridifasciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chortophaga' AND (species='viridifasciata' OR species='viridifasciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chortophaga' AND (species='viridifasciata' OR species='viridifasciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chortophaga' AND (junior_species='viridifasciata' OR junior_species='viridifasciata')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='Chortophaga' AND (species='viridifasciata' OR species='viridifasciata') 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 * FROM register WHERE sample_no=2169