Coordinate: 31° 57' N, 5° 19' 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=2159 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2159SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2159SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2159 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gryllulus' AND (junior_species='palmetorum' OR junior_species='palmetorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gryllulus' AND (species='palmetorum' OR species='palmetorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gryllulus' AND (species='palmetorum' OR species='palmetorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gryllulus' AND (junior_species='palmetorum' OR junior_species='palmetorum')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='Gryllulus' AND (species='palmetorum' OR species='palmetorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgomorpha' AND (junior_species='cognata' OR junior_species='cognata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrgomorpha' AND (species='cognata' OR species='cognata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrgomorpha' AND (species='cognata' OR species='cognata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgomorpha' AND (junior_species='cognata' OR junior_species='cognata')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='cognata' OR species='cognata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteracris' AND (junior_species='annulosus' OR junior_species='annulosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteracris' AND (species='annulosus' OR species='annulosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteracris' AND (species='annulosus' OR species='annulosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteracris' AND (junior_species='annulosus' OR junior_species='annulosus')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='annulosus' OR species='annulosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schistocera' AND (junior_species='gregaria' OR junior_species='gregaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schistocera' AND (species='gregaria' OR species='gregaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Schistocera' AND (species='gregaria' OR species='gregaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schistocera' AND (junior_species='gregaria' OR junior_species='gregaria')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='Schistocera' AND (species='gregaria' OR species='gregaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anacridium' AND (junior_species='aegyptium' OR junior_species='aegyptium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anacridium' AND (species='aegyptium' OR species='aegyptium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anacridium' AND (species='aegyptium' OR species='aegyptium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anacridium' AND (junior_species='aegyptium' OR junior_species='aegyptium')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='Anacridium' AND (species='aegyptium' OR species='aegyptium') 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='Duroniella' 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='Duroniella' AND (species='lucasi' OR species='lucasii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Duroniella' AND (species='lucasi' OR species='lucasii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Duroniella' 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='Duroniella' AND (species='lucasi' OR species='lucasii') 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='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='Sphingonotus' AND (junior_species='carinatus' OR junior_species='carinatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphingonotus' AND (species='carinatus' OR species='carinatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphingonotus' AND (species='carinatus' OR species='carinatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphingonotus' AND (junior_species='carinatus' OR junior_species='carinatus')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='carinatus' OR species='carinatus') 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='Ochrilidia' AND (junior_species='kraussi' OR junior_species='kraussii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochrilidia' AND (species='kraussi' OR species='kraussii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochrilidia' AND (species='kraussi' OR species='kraussii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochrilidia' AND (junior_species='kraussi' OR junior_species='kraussii')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='kraussi' OR species='kraussii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratettix' AND (junior_species='meridionalis' OR junior_species='meridionalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paratettix' AND (species='meridionalis' OR species='meridionalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paratettix' AND (species='meridionalis' OR species='meridionalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratettix' AND (junior_species='meridionalis' OR junior_species='meridionalis')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='Paratettix' AND (species='meridionalis' OR species='meridionalis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2159