Coordinate: 36° 31' N, 2° 54' E
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=2147 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2147SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2152SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2147 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conocephalus' AND (junior_species='conocephalus' OR junior_species='conocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conocephalus' AND (species='conocephalus' OR species='conocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conocephalus' AND (species='conocephalus' OR species='conocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conocephalus' AND (junior_species='conocephalus' OR junior_species='conocephalus')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='Conocephalus' AND (species='conocephalus' OR species='conocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontura' AND (junior_species='algerica' OR junior_species='algerica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odontura' AND (species='algerica' OR species='algerica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontura' AND (species='algerica' OR species='algerica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontura' AND (junior_species='algerica' OR junior_species='algerica')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='Odontura' AND (species='algerica' OR species='algerica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontura' AND (junior_species='microptera' OR junior_species='microptera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odontura' AND (species='microptera' OR species='microptera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontura' AND (species='microptera' OR species='microptera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontura' AND (junior_species='microptera' OR junior_species='microptera')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='Odontura' AND (species='microptera' OR species='microptera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrida' AND (junior_species='turrita' OR junior_species='turrita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acrida' AND (species='turrita' OR species='turrita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acrida' AND (species='turrita' OR species='turrita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrida' AND (junior_species='turrita' OR junior_species='turrita')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='turrita' OR species='turrita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Truxalis' AND (junior_species='annulata' OR junior_species='annulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Truxalis' AND (species='annulata' OR species='annulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Truxalis' AND (species='annulata' OR species='annulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Truxalis' AND (junior_species='annulata' OR junior_species='annulata')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='annulata' OR species='annulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Truxalis' AND (junior_species='nasuta' OR junior_species='nasuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Truxalis' AND (species='nasuta' OR species='nasuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Truxalis' AND (species='nasuta' OR species='nasuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Truxalis' AND (junior_species='nasuta' OR junior_species='nasuta')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='nasuta' OR species='nasuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calliptamus' AND (junior_species='wattenwylianus' OR junior_species='wattenwylianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calliptamus' AND (species='wattenwylianus' OR species='wattenwylianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calliptamus' AND (species='wattenwylianus' OR species='wattenwylianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calliptamus' AND (junior_species='wattenwylianus' OR junior_species='wattenwylianus')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='Calliptamus' AND (species='wattenwylianus' OR species='wattenwylianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pezotettix' AND (junior_species='giornae' OR junior_species='giornae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pezotettix' AND (species='giornae' OR species='giornae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pezotettix' AND (species='giornae' OR species='giornae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pezotettix' AND (junior_species='giornae' OR junior_species='giornae')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='Pezotettix' AND (species='giornae' OR species='giornae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eyprepocnemis' AND (junior_species='plorans' OR junior_species='plorans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eyprepocnemis' AND (species='plorans' OR species='plorans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eyprepocnemis' AND (species='plorans' OR species='plorans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eyprepocnemis' AND (junior_species='plorans' OR junior_species='plorans')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='Eyprepocnemis' AND (species='plorans' OR species='plorans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dociostaurus' AND (junior_species='jagoi' OR junior_species='jagoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dociostaurus' AND (species='jagoi' OR species='jagoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dociostaurus' AND (species='jagoi' OR species='jagoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dociostaurus' AND (junior_species='jagoi' OR junior_species='jagoii')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='Dociostaurus' AND (species='jagoi' OR species='jagoii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochrilidia' AND (junior_species='harterti' OR junior_species='hartertii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochrilidia' AND (species='harterti' OR species='hartertii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochrilidia' AND (species='harterti' OR species='hartertii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochrilidia' AND (junior_species='harterti' OR junior_species='hartertii')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='harterti' OR species='hartertii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omocestus' AND (junior_species='lucasi' OR junior_species='lucasii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Omocestus' AND (species='lucasi' OR species='lucasii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Omocestus' AND (species='lucasi' OR species='lucasii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omocestus' AND (junior_species='lucasi' OR junior_species='lucasii')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='Omocestus' AND (species='lucasi' OR species='lucasii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omocestus' AND (junior_species='africanus' OR junior_species='africanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Omocestus' AND (species='africanus' OR species='africanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Omocestus' AND (species='africanus' OR species='africanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omocestus' AND (junior_species='africanus' OR junior_species='africanus')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='Omocestus' AND (species='africanus' OR species='africanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omocestus' AND (junior_species='ventralis' OR junior_species='ventralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Omocestus' AND (species='ventralis' OR species='ventralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Omocestus' AND (species='ventralis' OR species='ventralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omocestus' AND (junior_species='ventralis' OR junior_species='ventralis')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='Omocestus' AND (species='ventralis' OR species='ventralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrotylus' AND (junior_species='patruelis' OR junior_species='patruelis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acrotylus' AND (species='patruelis' OR species='patruelis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acrotylus' AND (species='patruelis' OR species='patruelis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrotylus' AND (junior_species='patruelis' OR junior_species='patruelis')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='patruelis' OR species='patruelis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aiolopus' AND (junior_species='strepens' OR junior_species='strepens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aiolopus' AND (species='strepens' OR species='strepens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aiolopus' AND (species='strepens' OR species='strepens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aiolopus' AND (junior_species='strepens' OR junior_species='strepens')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='strepens' OR species='strepens') 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='Locusta' AND (junior_species='migratoria' OR junior_species='migratoria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Locusta' AND (species='migratoria' OR species='migratoria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Locusta' AND (species='migratoria' OR species='migratoria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Locusta' AND (junior_species='migratoria' OR junior_species='migratoria')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='Locusta' AND (species='migratoria' OR species='migratoria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oedipoda' AND (junior_species='caerulescens' OR junior_species='caerulescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oedipoda' AND (species='caerulescens' OR species='caerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oedipoda' AND (species='caerulescens' OR species='caerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oedipoda' AND (junior_species='caerulescens' OR junior_species='caerulescens')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='Oedipoda' AND (species='caerulescens' OR species='caerulescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphingonotus' AND (junior_species='azurescens' OR junior_species='azurescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphingonotus' AND (species='azurescens' OR species='azurescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphingonotus' AND (species='azurescens' OR species='azurescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphingonotus' AND (junior_species='azurescens' OR junior_species='azurescens')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='Sphingonotus' AND (species='azurescens' OR species='azurescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphingonotus' AND (junior_species='diadematus' OR junior_species='diadematus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphingonotus' AND (species='diadematus' OR species='diadematus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphingonotus' AND (species='diadematus' OR species='diadematus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphingonotus' AND (junior_species='diadematus' OR junior_species='diadematus')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='Sphingonotus' AND (species='diadematus' OR species='diadematus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphingonotus' AND (junior_species='rubescens' OR junior_species='rubescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphingonotus' AND (species='rubescens' OR species='rubescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphingonotus' AND (species='rubescens' OR species='rubescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphingonotus' AND (junior_species='rubescens' OR junior_species='rubescens')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='Sphingonotus' AND (species='rubescens' OR species='rubescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pamphagus' AND (junior_species='elephas' OR junior_species='elephas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pamphagus' AND (species='elephas' OR species='elephas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pamphagus' AND (species='elephas' OR species='elephas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pamphagus' AND (junior_species='elephas' OR junior_species='elephas')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='Pamphagus' AND (species='elephas' OR species='elephas') 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=2147