Coordinate: 40° 37' N, 73° 50' 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=1716 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1716SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1184SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1716 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='sericeus' OR junior_species='sericeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlaenius' AND (species='sericeus' OR species='sericeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlaenius' AND (species='sericeus' OR species='sericeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='sericeus' OR junior_species='sericeus')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='Chlaenius' AND (species='sericeus' OR species='sericeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenolophus' AND (junior_species='infuscatus' OR junior_species='infuscatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenolophus' AND (species='infuscatus' OR species='infuscatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenolophus' AND (species='infuscatus' OR species='infuscatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenolophus' AND (junior_species='infuscatus' OR junior_species='infuscatus')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='Stenolophus' AND (species='infuscatus' OR species='infuscatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='impunctifrons' OR junior_species='impunctifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlaenius' AND (species='impunctifrons' OR species='impunctifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlaenius' AND (species='impunctifrons' OR species='impunctifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='impunctifrons' OR junior_species='impunctifrons')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='Chlaenius' AND (species='impunctifrons' OR species='impunctifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonum' AND (junior_species='ferreum' OR junior_species='ferreum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agonum' AND (species='ferreum' OR species='ferreum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agonum' AND (species='ferreum' OR species='ferreum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonum' AND (junior_species='ferreum' OR junior_species='ferreum')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='Agonum' AND (species='ferreum' OR species='ferreum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonum' AND (junior_species='melanarium' OR junior_species='melanarium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agonum' AND (species='melanarium' OR species='melanarium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agonum' AND (species='melanarium' OR species='melanarium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonum' AND (junior_species='melanarium' OR junior_species='melanarium')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='Agonum' AND (species='melanarium' OR species='melanarium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omophron' AND (junior_species='labiatum' OR junior_species='labiatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Omophron' AND (species='labiatum' OR species='labiatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Omophron' AND (species='labiatum' OR species='labiatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omophron' AND (junior_species='labiatum' OR junior_species='labiatum')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='Omophron' AND (species='labiatum' OR species='labiatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='caudicalis' OR junior_species='caudicalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='caudicalis' OR species='caudicalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='caudicalis' OR species='caudicalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='caudicalis' OR junior_species='caudicalis')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='Pterostichus' AND (species='caudicalis' OR species='caudicalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonum' AND (junior_species='decorum' OR junior_species='decorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agonum' AND (species='decorum' OR species='decorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agonum' AND (species='decorum' OR species='decorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonum' AND (junior_species='decorum' OR junior_species='decorum')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='Agonum' AND (species='decorum' OR species='decorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecilus' AND (junior_species='lucublandus' OR junior_species='lucublandus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poecilus' AND (species='lucublandus' OR species='lucublandus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poecilus' AND (species='lucublandus' OR species='lucublandus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecilus' AND (junior_species='lucublandus' OR junior_species='lucublandus')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='Poecilus' AND (species='lucublandus' OR species='lucublandus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratachys' AND (junior_species='pumilus' OR junior_species='pumilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paratachys' AND (species='pumilus' OR species='pumilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paratachys' AND (species='pumilus' OR species='pumilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratachys' AND (junior_species='pumilus' OR junior_species='pumilus')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='Paratachys' AND (species='pumilus' OR species='pumilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scarites' AND (junior_species='subterraneus' OR junior_species='subterraneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scarites' AND (species='subterraneus' OR species='subterraneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scarites' AND (species='subterraneus' OR species='subterraneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scarites' AND (junior_species='subterraneus' OR junior_species='subterraneus')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='Scarites' AND (species='subterraneus' OR species='subterraneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oodes' AND (junior_species='americanus' OR junior_species='americanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oodes' AND (species='americanus' OR species='americanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oodes' AND (species='americanus' OR species='americanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oodes' AND (junior_species='americanus' OR junior_species='americanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oodes' AND (species='americanus' OR species='americanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dyschirius' AND (junior_species='aeneolus' OR junior_species='aeneolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dyschirius' AND (species='aeneolus' OR species='aeneolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dyschirius' AND (species='aeneolus' OR species='aeneolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dyschirius' AND (junior_species='aeneolus' OR junior_species='aeneolus')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='Dyschirius' AND (species='aeneolus' OR species='aeneolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omophron' AND (junior_species='nitidum' OR junior_species='nitidum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Omophron' AND (species='nitidum' OR species='nitidum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Omophron' AND (species='nitidum' OR species='nitidum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omophron' AND (junior_species='nitidum' OR junior_species='nitidum')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='Omophron' AND (species='nitidum' OR species='nitidum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omophron' AND (junior_species='tessellatum' OR junior_species='tessellatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Omophron' AND (species='tessellatum' OR species='tessellatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Omophron' AND (species='tessellatum' OR species='tessellatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omophron' AND (junior_species='tessellatum' OR junior_species='tessellatum')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='Omophron' AND (species='tessellatum' OR species='tessellatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oodes' AND (junior_species='amaroides' OR junior_species='amaroides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oodes' AND (species='amaroides' OR species='amaroides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oodes' AND (species='amaroides' OR species='amaroides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oodes' AND (junior_species='amaroides' OR junior_species='amaroides')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='Oodes' AND (species='amaroides' OR species='amaroides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='nemoralis' OR junior_species='nemoralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='nemoralis' OR species='nemoralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='nemoralis' OR species='nemoralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='nemoralis' OR junior_species='nemoralis')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='Carabus' AND (species='nemoralis' OR species='nemoralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nebria' AND (junior_species='lacustris' OR junior_species='lacustris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nebria' AND (species='lacustris' OR species='lacustris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nebria' AND (species='lacustris' OR species='lacustris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nebria' AND (junior_species='lacustris' OR junior_species='lacustris')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='Nebria' AND (species='lacustris' OR species='lacustris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calathus' AND (junior_species='gregarius' OR junior_species='gregarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calathus' AND (species='gregarius' OR species='gregarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calathus' AND (species='gregarius' OR species='gregarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calathus' AND (junior_species='gregarius' OR junior_species='gregarius')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='Calathus' AND (species='gregarius' OR species='gregarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clivina' AND (junior_species='rufa' OR junior_species='rufa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clivina' AND (species='rufa' OR species='rufa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clivina' AND (species='rufa' OR species='rufa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clivina' AND (junior_species='rufa' OR junior_species='rufa')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='Clivina' AND (species='rufa' OR species='rufa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clivina' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clivina' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clivina' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clivina' AND (junior_species='americana' OR junior_species='americana')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='Clivina' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonum' AND (junior_species='palustre' OR junior_species='palustre')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agonum' AND (species='palustre' OR species='palustre') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agonum' AND (species='palustre' OR species='palustre')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonum' AND (junior_species='palustre' OR junior_species='palustre')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='Agonum' AND (species='palustre' OR species='palustre') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='emarginatus' OR junior_species='emarginatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlaenius' AND (species='emarginatus' OR species='emarginatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlaenius' AND (species='emarginatus' OR species='emarginatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='emarginatus' OR junior_species='emarginatus')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='Chlaenius' AND (species='emarginatus' OR species='emarginatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dyschirius' AND (junior_species='globulosus' OR junior_species='globulosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dyschirius' AND (species='globulosus' OR species='globulosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dyschirius' AND (species='globulosus' OR species='globulosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dyschirius' AND (junior_species='globulosus' OR junior_species='globulosus')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='Dyschirius' AND (species='globulosus' OR species='globulosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratachys' AND (junior_species='proximus' OR junior_species='proximus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paratachys' AND (species='proximus' OR species='proximus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paratachys' AND (species='proximus' OR species='proximus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratachys' AND (junior_species='proximus' OR junior_species='proximus')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='Paratachys' AND (species='proximus' OR species='proximus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Badister' AND (junior_species='transversus' OR junior_species='transversus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Badister' AND (species='transversus' OR species='transversus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Badister' AND (species='transversus' OR species='transversus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Badister' AND (junior_species='transversus' OR junior_species='transversus')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='Badister' AND (species='transversus' OR species='transversus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omophron' AND (junior_species='americanum' OR junior_species='americanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Omophron' AND (species='americanum' OR species='americanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Omophron' AND (species='americanum' OR species='americanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omophron' AND (junior_species='americanum' OR junior_species='americanum')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='Omophron' AND (species='americanum' OR species='americanum') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1716